ORA-00904
I already looked for the error on the internet and I can't solve it anyone know why it is?
2022-04-1204:00:09,921GMT*8*EXCP0001*0*0*prdmkt12*NA*NA*B7JIQTEZ8CKPENRYCS3SH8AA4NMA5SRYUA*System*PegaMKT-Work*MktCL:PRD*29ca1c17a575f0e92ceacd130dc9b2e3*N*1*B7JIQTEZ8CKPENRYCS3SH8AA4NMA5SRYUA*2509*PegaRULES-Batch-198*STANDARD*Rule_Obj_Activity.WriteToFile.PegaMKT_Data_Outbound_Queue.Action*NA*PegaMKT-Data-Outbound-Queue.OutboundAgentHelper*Rule-Obj-Activity:EstablishContext*PEGAMKT-DATA-OUTBOUND-QUEUE WRITETOFILE #20180514T182933.565 GMT Step: 17 Circum: 0*NA****NA*NA*PegaMKT-Data-Outbound-Queue*NA*PegaMKT-Data-Outbound-Queue*NA*Java;RULE-OBJ-ACTIVITY PEGAMKT-DATA-OUTBOUND-QUEUE WRITETOFILE #20180514T182933.565 GMT Step: 17 Circum: 0;doActivity Rule-Obj-Activity:WriteToFile;Call WriteToFile;RULE-OBJ-ACTIVITY PEGAMKT-DATA-OUTBOUND-QUEUE OUTBOUNDAGENTHELPER #20180514T182933.424 GMT Step: 1 Circum: 0;2 additional frames in stack;*FilePath=[removed];ThreadCount=[removed];ListType=[removed];FileName=[removed];pyTempPlaceHolder=TempPlaceHolder;TemplateFileAlreadyExists=[removed];*[MSG][WriteToFile: Outbound File Batch processing failed.
I already looked for the error on the internet and I can't solve it anyone know why it is?
2022-04-1204:00:09,921GMT*8*EXCP0001*0*0*prdmkt12*NA*NA*B7JIQTEZ8CKPENRYCS3SH8AA4NMA5SRYUA*System*PegaMKT-Work*MktCL:PRD*29ca1c17a575f0e92ceacd130dc9b2e3*N*1*B7JIQTEZ8CKPENRYCS3SH8AA4NMA5SRYUA*2509*PegaRULES-Batch-198*STANDARD*Rule_Obj_Activity.WriteToFile.PegaMKT_Data_Outbound_Queue.Action*NA*PegaMKT-Data-Outbound-Queue.OutboundAgentHelper*Rule-Obj-Activity:EstablishContext*PEGAMKT-DATA-OUTBOUND-QUEUE WRITETOFILE #20180514T182933.565 GMT Step: 17 Circum: 0*NA****NA*NA*PegaMKT-Data-Outbound-Queue*NA*PegaMKT-Data-Outbound-Queue*NA*Java;RULE-OBJ-ACTIVITY PEGAMKT-DATA-OUTBOUND-QUEUE WRITETOFILE #20180514T182933.565 GMT Step: 17 Circum: 0;doActivity Rule-Obj-Activity:WriteToFile;Call WriteToFile;RULE-OBJ-ACTIVITY PEGAMKT-DATA-OUTBOUND-QUEUE OUTBOUNDAGENTHELPER #20180514T182933.424 GMT Step: 1 Circum: 0;2 additional frames in stack;*FilePath=[removed];ThreadCount=[removed];ListType=[removed];FileName=[removed];pyTempPlaceHolder=TempPlaceHolder;TemplateFileAlreadyExists=[removed];*[MSG][WriteToFile: Outbound File Batch processing failed. ][STACK][com.pega.pegarules.pub.PRRuntimeException: Cannot list the database<CR> at com.pega.decision.dsm.batch.RDBBatchReader.<init>(RDBBatchReader.java:81)<CR> at com.pegarules.generated.createSQLBasedIterator_080101_373222742713466010.createSQLBasedIterator08_01_01(createSQLBasedIterator_080101_373222742713466010.java:130)<CR> at com.pegarules.generated.createSQLBasedIterator_080101_373222742713466010.invoke(createSQLBasedIterator_080101_373222742713466010.java:106)<CR> at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222)<CR> at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9272)<CR> at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275)<CR> at com.pegarules.generated.activity.ra_action_writetofile_ae1b682b9d301fd14c4b6a6f26e7d278.step17_circum0(ra_action_writetofile_ae1b682b9d301fd14c4b6a6f26e7d278.java:1592)<CR> at com.pegarules.generated.activity.ra_action_writetofile_ae1b682b9d301fd14c4b6a6f26e7d278.perform(ra_action_writetofile_ae1b682b9d301fd14c4b6a6f26e7d278.java:398)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3557)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10916)<CR> at com.pegarules.generated.activity.ra_action_outboundagenthelper_b9b33c3641238f9c699d5c9f5bc7f77d.step1_circum0(ra_action_outboundagenthelper_b9b33c3641238f9c699d5c9f5bc7f77d.java:215)<CR> at com.pegarules.generated.activity.ra_action_outboundagenthelper_b9b33c3641238f9c699d5c9f5bc7f77d.perform(ra_action_outboundagenthelper_b9b33c3641238f9c699d5c9f5bc7f77d.java:70)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3557)<CR> at com.pega.pegarules.session.internal.async.agent.QueueProcessor.runActivity(QueueProcessor.java:798)<CR> at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:655)<CR> at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1139)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1366)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1109)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:990)<CR> at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:805)<CR> at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)<CR> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)<CR> at java.lang.Thread.run(Thread.java:748)<CR>Caused by: com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: 904 SQLState: 42000 Message: ORA-00904: "OFFER"."PXIDENTIFIER": invalid identifier<CR><CR>DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00904: "OFFER"."PXIDENTIFIER": invalid identifier<CR><CR> | SQL Code: 904 | SQL State: 42000<CR><CR>From: (B7JIQTEZ8CKPENRYCS3SH8AA4NMA5SRYUA) <CR> SQL: SELECT STAG.PXCREATEDATETIME AS "pxCreateDateTime", STAG.PROGRAMRUN AS "ProgramRun", STAG.CUSTOMERID AS "CustomerID", STAG.RANKID AS "RankID", STAG.DESTINATIONTYPE AS "DestinationType", STAG.TEMPLATENAME AS "TemplateName", STAG.TREATMENTNAME AS "TreatmentName", STAG.COLUMNSPAYLOAD AS "ColumnsPayload", STAG.VALUESPAYLOAD AS "ValuesPayload", OFFER.PXIDENTIFIER AS "pxIdentifier", STAG.OFFERCLASSNAME as "OfferClassName" FROM IHUSER.MKT_STAGING STAG LEFT OUTER JOIN PEGADATA.pr_dm_proposition OFFER ON STAG.CUSTOMERID = OFFER.pyName AND STAG.RANKID = OFFER.PXRANK AND STAG.PROGRAMRUN = OFFER.PYWORKID WHERE STAG.DESTINATIONTYPE = 'FILE' AND STAG.STATUS = 'NEW' AND STAG.TEMPLATENAME = 'SMSFileTemplate' AND STAG.OFFERCLASSNAME = 'Entel-Mkt-SR-PricePlanManagement-PretoPost'<CR><CR>Caused by SQL Problems.<CR>Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: "OFFER"."PXIDENTIFIER": invalid identifier<CR><CR> at com.pega.pegarules.data.internal.access.ExceptionInformation.createAppropriateExceptionDueToDBFailure(ExceptionInformation.java:381)<CR> at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:360)<CR> at com.pega.pegarules.data.internal.access.Lister.convertSqlExceptionToDatabaseException(Lister.java:583)<CR> at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:421)<CR> at com.pega.pegarules.data.internal.access.Lister.list(Lister.java:185)<CR> at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:2945)<CR> at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:2937)<CR> at com.pega.decision.dsm.batch.RDBBatchReader.<init>(RDBBatchReader.java:73)<CR> ... 23 more<CR>Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "OFFER"."PXIDENTIFIER": invalid identifier<CR><CR> at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)<CR> at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)<CR> at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)<CR> at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)<CR> at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)<CR> at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)<CR> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)<CR> at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)<CR> at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)<CR> at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)<CR> at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)<CR> at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)<CR> at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)<CR> at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3887)<CR> at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1079)<CR> at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:119)<CR> at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:510)<CR> at com.pega.pegarules.data.internal.access.Lister.listWithResultPackager(Lister.java:399)<CR> ... 27 more<CR>Caused by: Error : 904, Position : 343, Sql = SELECT STAG.PXCREATEDATETIME AS "pxCreateDateTime", STAG.PROGRAMRUN AS "ProgramRun", STAG.CUSTOMERID AS "CustomerID", STAG.RANKID AS "RankID", STAG.DESTINATIONTYPE AS "DestinationType", STAG.TEMPLATENAME AS "TemplateName", STAG.TREATMENTNAME AS "TreatmentName", STAG.COLUMNSPAYLOAD AS "ColumnsPayload", STAG.VALUESPAYLOAD AS "ValuesPayload", OFFER.PXIDENTIFIER AS "pxIdentifier", STAG.OFFERCLASSNAME as "OfferClassName" FROM IHUSER.MKT_STAGING STAG LEFT OUTER JOIN PEGADATA.pr_dm_proposition OFFER ON STAG.CUSTOMERID = OFFER.pyName AND STAG.RANKID = OFFER.PXRANK AND STAG.PROGRAMRUN = OFFER.PYWORKID WHERE STAG.DESTINATIONTYPE = 'FILE' AND STAG.STATUS = 'NEW' AND STAG.TEMPLATENAME = 'SMSFileTemplate' AND STAG.OFFERCLASSNAME = 'Entel-Mkt-SR-PricePlanManagement-PretoPost', OriginalSql = SELECT STAG.PXCREATEDATETIME AS "pxCreateDateTime", STAG.PROGRAMRUN AS "ProgramRun", STAG.CUSTOMERID AS "CustomerID", STAG.RANKID AS "RankID", STAG.DESTINATIONTYPE AS "DestinationType", STAG.TEMPLATENAME AS "TemplateName", STAG.TREATMENTNAME AS "TreatmentName", STAG.COLUMNSPAYLOAD AS "ColumnsPayload", STAG.VALUESPAYLOAD AS "ValuesPayload", OFFER.PXIDENTIFIER AS "pxIdentifier", STAG.OFFERCLASSNAME as "OfferClassName" FROM IHUSER.MKT_STAGING STAG LEFT OUTER JOIN PEGADATA.pr_dm_proposition OFFER ON STAG.CUSTOMERID = OFFER.pyName AND STAG.RANKID = OFFER.PXRANK AND STAG.PROGRAMRUN = OFFER.PYWORKID WHERE STAG.DESTINATIONTYPE = 'FILE' AND STAG.STATUS = 'NEW' AND STAG.TEMPLATENAME = 'SMSFileTemplate' AND STAG.OFFERCLASSNAME = 'Entel-Mkt-SR-PricePlanManagement-PretoPost', Error Msg = ORA-00904: "OFFER"."PXIDENTIFIER": invalid identifier<CR><CR> at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)<CR> ... 44 more<CR>]*