Prev
Next
Forums Integration / Customization S3 Customization/Development

GEN/QUEUEDJOB.

 2 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Chesca
Veteran Member Send Private Message
Posts: 490
Veteran Member
10/1/2013 2:34 PM
Hello, I am trying to run a job and it hangs. I checked the logs, has anybody seem the following error before and how can I resolve it?

File GEN/QUEUEDJOB.

tsStoreDBRec error is Bad data in field(s) (82).

Additional information is 1722.

Additional Text is:

StoreSqlRec(GEN9."QUEUEDJOB")

OCIStmtExecute() returned OCI_ERROR code 1722 parse offset 30343168 (

ORA-01722: invalid number

jaherb
Veteran Member Send Private Message
Posts: 164
Veteran Member
10/2/2013 1:52 PM
Not sure what your program is doing, however when I get into situations like this, I will run in Animator and see where the job stops at and then query the fields involved. As the message states you apparently have some invalid data in one of your fields. Are you updating a Lawson table or a custom table?
Chesca
Veteran Member Send Private Message
Posts: 490
Veteran Member
10/3/2013 1:51 PM
This was actually a job error and not a program. One of our user was testing LT101 and had scheduled jobs manually via macro in S3. The job submission fail due to invalid start time data. The next jobs were scheduled to be submitted every 10 minutes and all the jobs queued up. We had to restart the jobqueue. Thank you for your prompted response.