You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Application Engine Error

2 replies [Last post]
Guest's picture
Guest

i am getting the below error while running Application Engine Program .

Could you tell me what would be the reason ....

File: E:\pt84920b-retail\peopletools\SRC\PSAPPENG\aebuf.cppSQL error. Stmt #: 574 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PROCESS_INSTANCE'.
Failed SQL stmt:INSERT INTO PS_ECL_ADVTRA_AET (PROCESS_INSTANCE,PRCSOUTPUTDIR,EMPLID,DESCRSHORT,ECL_ARF_REQ_ID,ECL_CLAIM_REQ_ID,NAME,DEPTID,ECL_COST_CENTER,ECL_APPROVER_ID,NAME1,ZIN_ZONE,LOCATION,DESCR,ECL_STATUS,EMPL_STATUS,ECL_GL_CODE,ECL_ADV_AMOUNT,ECL_TOTAL_AMT) VALUES (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:15,:16,:17,:18,:19)
Message Set Number: 200
Message Number: 0
Message Reason: File: E:\pt84920b-retail\peopletools\SRC\PSAPPENG\aebuf.cppSQL error. Stmt #: 574 Error Position: 0 Return: 8010 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'PROCESS_INSTANCE'.
Failed SQL stmt:INSERT INTO PS_ECL_ADVTRA_AET (PROCESS_INSTANCE,PRCSOUTPUTDIR,EMPLID,DESCRSHORT,ECL_ARF_REQ_ID,ECL_CLAIM_REQ_ID,NAME,DEPTID,ECL_COST_CENTER,ECL_APPROVER_ID,NAME1,ZIN_ZONE,LOCATION,DESCR,ECL_STATUS,EMPL_STATUS,ECL_GL_CODE,ECL_ADV_AMOUNT,ECL_TOTAL_AMT) VALUES (:1,:2,:3,:4,: (200,0)

Ashar's picture
User offline. Last seen 3 years 25 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Application Engine Error

Is the field PROCESS_INSTANCE existing in the record? What type of record is it? Work Record or SQL Table?
Are you explicitly trying to insert row into AET record or are you using %Select construct?

Lepa's picture
User offline. Last seen 44 weeks 4 days ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Application Engine Error

Can you run the below in ur database with no errors?

Select PROCESS_INSTANCE,PRCSOUTPUTDIR,EMPLID,DESCRSHORT,ECL_ARF_REQ_ID,ECL_CLAIM_REQ_ID,NAME,DEPTID,ECL_COST_CENTER,ECL_APPROVER_ID,NAME1,ZIN_ZONE,LOCATION,DESCR,ECL_STATUS,EMPL_STATUS,ECL_GL_CODE,ECL_ADV_AMOUNT,ECL_TOTAL_AMT from PS_ECL_ADVTRA_AET;

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog