Question

2
Replies
31
Views
Close popover
Naveen Bandaru (NaveenK88)
infosys

infosys
NL
NaveenK88 Member since 2020 2 posts
infosys
Posted: February 16, 2021
Last activity: March 8, 2021

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 :

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>]*   

***Edited by Moderator Marissa to update Platform Capability tags****
Pega Business Intelligence Exchange 8.4 System Administration Financial Services Lead System Architect