Content Management and Capture

 View Only
Expand all | Collapse all

My App can't create a new batch during testing, on the previous day can create a new batch normally

  • 1.  My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Mon February 28, 2022 09:43 AM
    Hi I want to ask about the new batch in datacap

    My App can't create a new batch during testing, on the previous day can create a new batch normally,

    if i create new app, this new app can create new batch normally

    why this happened? and how to fix it?

    Thanks for the support and assistance in this matter.


    Best Regards,

    Lintang Gilang Pratama




    ------------------------------
    Lintang Gilang
    ------------------------------


  • 2.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Tue March 01, 2022 04:28 AM
    Hi

    You need to select a task profile before you can create new batch. See top left corner <select task profile> drop down.

    Regards

    RP

    ------------------------------
    Ranjit Patel
    ------------------------------



  • 3.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Tue March 01, 2022 09:47 PM
    Thank you for the response Ranjit Patel

    For the app I'm developing, I've tried it
    1. Datacap server running
    2. click "task profile" as "Scan from multiformat disk"
    3. right click on "Vsan Multi"
    4. Select "New"

    New batch is not created by datacap studio,

    If I create a new application (which is still the new default) then the above process I run, a new batch is created successfully in datacap studio for the new application

    how to fix it?

    ------------------------------
    Lintang Gilang
    ------------------------------



  • 4.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Wed March 02, 2022 03:29 AM
    Hi Lintang,

    I have seen this issue when using Microsoft Access for admin and engine Database. When the engine DB is almost 2GB size, I was not able to create new batches. If we replace the engine DB with another empty engine DB, the application starts working.

    Thanks,
    Geetha


    ------------------------------
    Geetha Jini C
    ------------------------------



  • 5.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Wed March 02, 2022 10:45 AM
    Hi Geetha

    thank you for the response

    I attached my app size detail view



    I have reviewed my app to reduce its size but only slightly reduced, what is causing the size to be so big? Is it a rule, a rule or a function?

    based on your statement how to replace engine DB with another empty engine DB?

    ------------------------------
    Lintang Gilang
    ------------------------------



  • 6.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Wed March 02, 2022 12:22 PM
    Hi

    Most likely cause that you have to many records in qstats and taskstats tables in engine DB.

    Regards

    RP

    ------------------------------
    Ranjit Patel
    ------------------------------



  • 7.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Thu March 03, 2022 05:20 AM

    Hi Lintang,

     You can create a sample application, then copy the admin DB of your original application to the admin DB of Sample application using Datacap Application Copy tool. Now, use the sample application's admin and engine DB in your application. This engine DB will not have any batches and will be of smaller size. You can keep a backup of this engine DB and replace it whenever the issue occurs.

    Also, may be you can check for these settings in application manager and disable it as shown in screenshot, if not required.



    Thanks,
    Geetha



    ------------------------------
    Geetha Jini C
    ------------------------------



  • 8.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Thu March 03, 2022 08:59 AM
    Hi Geetha

    Thank you for the response

    I just want to make sure "create a sample app"
    1. The old app name is ABC
    2. The name of the sample application is XYZ (which is still the new default)
    3. Open the Datacap application copy tool
    4. Copy from ABC to XYZ
    5. Do the settings in the app manager and disable it as shown in the previous screenshot
    6. My last app is XYZ

    Please correct me if I'm wrong

    Thank You

    ------------------------------
    Lintang Gilang
    ------------------------------



  • 9.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Thu March 03, 2022 11:44 AM
    Hi Lintang,

    Need not copy the complete application to XYZ. Copy the DB of ABC to XYZ using Datacap app copy tool (refer screenshot). Take both admin and engine DBs of  XYZ and use it with ABC. XYZ will be just dummy and has to be removed.



    Thanks,
    Geetha

    ------------------------------
    Geetha Jini C
    ------------------------------



  • 10.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Thu March 03, 2022 08:57 PM
    Hi Geetha

    I really thank you for your fast response

    I just want to make sure 
    1. The old app name is ABC
    2. The name of the sample application is XYZ (which is still the new default)
    3. Open the Datacap application copy tool
    4. Copy from ABC to XYZ, like this


    5. Take both admin and engine DBs of XYZ and use it with ABC
         --> Delete ABCAdm.mdb and ABCEng.mdb in ABC, copy and paste from XYZ to ABC, is this right?
    6. Remove XYZ app
    7. Do the settings in the app manager and disable it as shown in the previous screenshot

    8. My final app is ABC

    By the way, I got an error like this while copying using Datacap application copy tool



    Please correct me if I'm wrong

    Thank You

    ------------------------------
    Lintang Gilang
    ------------------------------



  • 11.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Fri March 04, 2022 08:37 AM

    Hi Lintang,

    Yes. You have mentioned the right steps. Enable "Clear audit table" checkbox. Actually, by following this method, we are trying to get admin and engine DB with no audit logs and batches information.

    I don't know about the error you have shared while copying the tables. 

    Please have a look at the below support page for increase in size of engine DB.
    https://www.ibm.com/support/pages/how-clean-out-large-volumes-old-and-stale-records-datacap-engine-database-tables

    May be you can also try below method as you mentioned that you cannot copy admin DB.
    1. Copy XYZ engine DB to your ABC application folder.
    2. Open ABC admin DB using Microsoft Access, Goto adminfo table and get the value of dbindex column.
    3. Open XYZ engine DB using Microsoft Access, Goto enginfo table and update the value of adminfo's dbindex to dbindex column so that it is the same as the value in the adminfo table. Save the file.
    4.  Now you can use XYZ engine DB (which is empty now with no batches), in your ABC application.  

    Thanks,
    Geetha



    ------------------------------
    Geetha Jini C
    ------------------------------



  • 12.  RE: My App can't create a new batch during testing, on the previous day can create a new batch normally

    Posted Mon March 07, 2022 02:59 AM
    Hi Geetha

    I really appreciate your feedback, discussion with you is very valuable

    I've tried the steps you gave and it worked really well
    1. The old app name is ABC
    2. The name of the sample application is XYZ (which is still the new default)
    3. Take the dbindex value from ABC
    4. Open XYZEng.mdb
    5. Go to the enginfo table then update the dbindex value according to ABC
    6. Save the file
    7. Rename XYZEng.mdb to ABCEng.mdb
    8. Copy and Replace ABCEng.mdb in ABC


    Thanks,
    Lintang Gilang

    ------------------------------
    Lintang Gilang
    ------------------------------