Micros POS Direct Posting Service R&A Error

[GeminiBoy]

After Upgrade to Simphony 19.4. from 18.2.12, I get the below error in DPS Log file after posting transaction from CAPS machine.

ErrorCode: ERR_GENERIC_ERROR. Error: ORA-00904: "ORGANIZATIONID": invalid identifier. StackTrace: at EMC.Data.Sql.SqlInsert.RunCmd(Boolean fReturnID‚ String strSeq)

at Micros.DPS.NVPCheckWriter.AddReferenceMessageID(NVPCheck check)

at Micros.DPS.NVPCheckWriter.WriteValidatedData(List`1 CheckList‚ StatsToken statsToken)

Has anyone had this issue before?

 

[Jackba]

Have you also upgraded you R & A ?

 

[GeminiBoy]

Hi Jackba,

I am running R&A 8.5.1

 

[Jackba]

You need to upgrade at least up to 9.1

 

[GeminiBoy]

with 9.1, I always have issues with signing certificate (CSR) for SSL

Is there anyway you could help with a tool to use in signing the CSR

 

[Jackba]

You can use java keytool to generate the .jks file.

Also before the upgrade you need to run all the 8.5.1 patches