DataDeploy: Null pointer exception

Hi there,

We are facing an exception while doing DataDeploy using Version 5.6.0. Sometimes while deploying it gives us a Null Pointer Exception... like:

BuildSortedRows Smiley Frustrated

ELECT HELP_TERM_ID,IDENTIFIER_TYPE,IDENTIFIER_KEY,IS_EXPIRED,CO MPANY,RES_BUS,TELCO_UVERSE,STATE_ID,TO_CHAR(LAST_UPDATED_DATE,'MM/DD/YYYY') AS L AST_UPDATED_DATE,LAST_UPDATED_USER,HELP_DETAIL_ID FROM IWTEMP_E217EC6C ORDER BY HELP_DETAIL_ID ERROR:Exception occured: null java.lang.NullPointerException at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.BuildRows(TDbSchemaUpda teHelper.java:497) at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildSortedRows(TDbSchemaRow Sort.java:304) :q

If anyone had gone through such an error ... please help. Else other suggestions are welcome as well.

Find more posts tagged with

Comments

Migrateduser

there is a space between in your SQL statement in CO MPANY. This could be the possible reason for that. Which data-deploy-configuration file you are using into your deployment xml.

Let me know.

Migrateduser

There's that space which Rishi suggested but your data might also have a null primary key, which may otherwise be causing this error. When you respond, please attach your config and the data you're trying to deploy (DCR, XML, or otherwise)