BIX : DATE Type Atrribute Issue in Extraction
I have property which is DATE in Pega ,BIX rule also i have defined it as DATE and Database also column type corresponding also DATE. We are using out put format in BIX as Database. So while running the BIX extraction failed and only few records processed. SQL Exception :ORA-01861: De constante komt niet overeen met de notatiestring.
Log Error :
I have property which is DATE in Pega ,BIX rule also i have defined it as DATE and Database also column type corresponding also DATE. We are using out put format in BIX as Database. So while running the BIX extraction failed and only few records processed. SQL Exception :ORA-01861: De constante komt niet overeen met de notatiestring.
Log Error :
2021-02-15T14:48:23,975Z [workmanager_PRPC : 4] [ ] [ IRBix:01.01.01] ( internal.access.ExtractImpl) ALERT naveen - 2021-02-15 14:48:23,975 GMT*8*EXCP0001*0*0*c7153affe95bf47b46af383655ddb0ad*NA*NA*BNP8PGEB781OW2KH2DHONIO1SRS5C2MRDA*naveen*RBG-IRBix-Work*IRBix:01.01.01*c217600882638e8c82 22a3714a8b0164*Y*1*BNP8PGEB781OW2KH2DHONIO1SRS5C2MRDA*3578*WorkManager.workmanager_PRPC : 4*STANDARD*com.pega.pegarules.data.internal.access.ExtractImpl*NA*Rule-Admin-Extract.runExtract*Rule-Obj-Activity:ApplicationSetup*RULE-ADMIN-EXTRAC T RUNEXTRACT #20180713T143905.595 GMT Step: 1 Circum: 0*NA****NA*NA*NA*NA*NA*NA*java;RULE-OBJ-ACTIVITY RULE-ADMIN-EXTRACT RUNEXTRACT #20180713T143905.595 GMT Step: 1 Circum: 0;doActivity Rule-Obj-Activity:runExtract;initial Executable;0 additional frames in stack;*schemaFile=[removed];pzHarnessID=[removed];purpose=[removed];pyCreateDateTime=[removed];AJAXTrackID=18;pyReturnsResponse=[removed];pzIsEncryp tedActionString=[removed];pzActivityParamsEncrypted=[removed];pzUseCurrentAccessGroupForChild=[removed];pxCreateDateTime=[removed];pzFromFrame=[remo ved];ClassName=[removed];inStandardsMode=true;pzActionID=[removed];rowNumber=[removed];pzActivity=[removed];IDNumber=[removed];pzActivityParams=[rem oved];generateManifestSchema=[removed];pzPrimaryPageName=[removed];zipFileName=[removed];pzTransactionId=[removed];UITemplatingStatus=[removed];pxOb jClass=@baseclass;generateSchema=[removed];manifestSchemaFile=[removed];*[MSG][Severe SQL Exception: ORA-01861: De constante komt niet overeen met de notatiestring.<CR>][STACK][java.sql.BatchUpdateException: ORA-01861: De constante komt niet overeen met de notatiestring.<CR><CR> at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032)<CR> at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364)<CR> at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839)<CR> at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)<CR> at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteBatch(WSJdbcPreparedStatement.java:1146)<CR> at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:856)<CR> at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeBatch(DatabasePreparedStatementImpl.java:491)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.insertRowsBatchMode(ExtractImpl.java:4453)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.insertRowsBatchModeForDatabaseType(ExtractImpl.java:5750)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.extractData(ExtractImpl.java:2711)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.doExtract(ExtractImpl.java:2083)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.runExtract(ExtractImpl.java:1296)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.run(ExtractImpl.java:1129)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1397)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1140)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:947)<CR> at com.pega.pegarules.data.internal.access.ExtractImpl.runEngineExtract(ExtractImpl.java:1112)<CR> at com.pega.pegarules.data.internal.access.DatabaseImpl.executeExtract(DatabaseImpl.java:3588)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.executeExtract(Executable.java:8796)<CR> at com.pegarules.generated.activity.ra_action_runextract_c31b2b8088d1781c0f96f51842fa3c31.step1_circum0(ra_action_runextract_c31b2b8088d1781c0f96f51842 fa3c31.java:176)<CR> at com.pegarules.generated.activity.ra_action_runextract_c31b2b8088d1781c0f96f51842fa3c31.perform(ra_action_runextract_c31b2b8088d1781c0f96f51842fa3c31 .java:76)<CR> at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:2814)<CR> at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:653)<CR> at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:580)<CR> at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:511)<CR> at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:304)<CR> at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:360)<CR> at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:1158)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1397)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1140)<CR> at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1021)<CR> at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:818)<CR> at com.pega.pegarules.session.internal.async.Agent.runBatchTask(Agent.java:859)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:252)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:178)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:338)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:282)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:231)<CR> at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source)<CR> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:55)<CR> at java.lang.reflect.Method.invoke(Method.java:508)<CR> at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:385)<CR> at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:427)<CR> at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:225)<CR> at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:247)<CR> at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:173)<CR> at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:157)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:67)<CR> at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:88)<CR> at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)<CR> at java.security.AccessController.doPrivileged(AccessController.java:647)<CR> at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:797)<CR> at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)<CR> at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)<CR> at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)<CR>]*
Infosys
AU
@NaveenK88 did you find a solution to this issue?
Cognitonic Systems Australia
AU
@NaveenK88 Whenever BIX Extract is executed Pega validates the data that is being extracted. For instance, in your scenario, the attribute that is configured is of Date data type: in the BIX extract rule against the attribute it is specified as Date and in the target database column type is also date. When Pega is extracting the data if any of the work objects containing this attribute is holding the invalid date format or date-time value then those instances will be failed.
The following approaches will fix the issue:
1. By default pega converts Date properties to VARCHAR(8) to overcome cross DB portability when specified in the BIX Extract. If this is changed from String to Date then try reverting the format type to String in the BIX extract for the Date field. This will create the target DB column as a string and the data will be extracted without any issue.
2. If you still want to change the output data type to Date instead of String in BIX Extract rule then first identify the list of all instance for which issues exists(this can be grabbed from PegaBIX.log) and do a data fix with proper date format and then re-extract the data freshly. This will also solve the issue.
Reference link for data type formats:
Regards,
Chaitanya.