AnsweredAssumed Answered

ERROR ON PRINT INVOICE PAGE

Question asked by ArunMohan on Dec 17, 2010
Latest reply on Feb 4, 2011 by Abhi
We upgraded our test environment from 8.1 to 12.0 then to 12.1. We are in
process of testing the clarity application. When we tried to print invoice
which comes under external billing section we got "System error. Contact
system administrator".

ERROR 2010-12-15 14:15:40,382 [http-443-5] niku.xql2
(USX19256:6905076__212d0ffd:revmgr.printSelectedInvoices) Internal
Processing exception
com.niku.union.persistence.PersistenceException:
SQL error code: 515
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Cannot insert
the value NULL into column 'JOB_DEFINITION_ID', table
'niku.niku.CMN_SCH_JOBS'; column does not allow nulls. INSERT fails.
SQL error code: 3621
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]The statement
has been terminated.
Executed:
INSERT INTO CMN_SCH_JOBS
( ID, JOB_DEFINITION_ID, NAME, START_DATE,
END_DATE, SCHEDULE_DATE, MINUTES, HOURS,
MONTHS, DAYS_OF_MONTH, DAYS_OF_WEEK,
PRIORITY, STATUS_CODE,
RECURRENCE_TYPE,
CREATED_DATE, CREATED_BY, LAST_UPDATED_DATE, LAST_UPDATED_BY
)
VALUES ( ?, ?, ?, ?,
?, ?, ?, ?,
?, ?, ?,
?, ?,
?,
?, ?, ?, ?)

Could anyone help on this?


Thanks

Arun

Outcomes