Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  SQL2000 Server Agent Job error

Author  Topic  SSG Starting Member 4 Posts Posted - 2009-09-08 : 09:44:33 I am trying to correct a problem with a SQL job that send data to our AS400 from SQL database. There are several processes running, and I am trying to figure out why the timesheet transfer is not running correctly. First, there was a linked server issue,, which I got it corrected. I was then getting the message to run the RECONFIGURE. This msg read: configuration option'allow updates'chgd from 0 to 0. Run the RECONFIGURE. I could not figure out how to do this, but we re-booted the server which I think might have corrected that problem. However, the job that I need to run, which is run every ten minutes, is erroring. When I view the jobhistory info, this is the message: Executed as user: SC\ASC98SQL$. OLE DB provider 'DB2OLEDB' could not INSERT INTO table '[Rowset_1]'. [SQLSTATE 42000] (Error 7343) [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'DB2OLEDB' IRowsetChange::InsertRow returned 0x80040e21: The provider return DB_E_ERRORSOCCURRED, but none of the columns is in error status. Data status sent to the provider: [COLUMN_NAME=LEDVCD STATUS=DBSTATUS_S_OK], [COLUMN_NAME=LELHID STATUS=DBSTATUS_S_OK], [COLUMN_NAME=LEID STATUS=DBSTATUS_S_OK], [COLUMN_NAME=LELBID STATUS=DBSTATUS_S_OK], [COLUMN_NAME=... [SQLSTATE 01000] (Error 7300). The step failed. This is the job that updates data to our AS400 database. I am not sure what this error is trying to tell me, besides the fact that it failed. The other jobs that pull info from the AS400 to the SQL database, seem to be running, this job SENDs to the AS400 ( it is the only job that does a send) and it is failing. I tracked thru each of the data elements, and matched then to what is in the SQL DB. The next element after LELBID is a date field. Not sure if this is where the hangup is. The date format has not changed in SQL table or AS400 table. Any ideas of what else I should check?