Simphony CAPS Not Posting Sales to R&A

[GeminiBoy]

My Simphony CAPS is not posting sales to R&A.

I have attached the error as seen from the log file on CAPS.

Meanwhile, whenever any transaction is carried out, the DPS Log shows that a transaction is coming through but at the end nothing still get posted to R&A

 

[Niko S]

You can check the transaction transfer to Dbcreate or not, and check the DPS log.
Or try to restart the DPS service. Could please upload the egatewaylog and DPS ?

 

[GeminiBoy]

Attached is the egateway log from CAPS and DPS LOG

 

[GeminiBoy]

Here is the DPS Log

 

[Niko S]

Hi King
It seems your check is not send to decreate database.
You can use SMSS and connect to the dbcreate database ,
select * from checks where checknum= '***' to see the check posted to dbcreate or not.

 

[GeminiBoy]

Ki Niko,

Many thanks for your kind reponse.

Are you talking about CheckPostingDB?

Which database is dbcreate?

 

[Niko S]

Hi King,
Which version do you use ?

Dbcreate is a schema in MCRSPOS.

 

[GeminiBoy]

I HAVE Sim 18.2.12

R&A: 8.5.1

 

[Niko S]

Hi King

Connect your DB and use SQL developer to login the DB, then select dbcreate datebase.

 

[GeminiBoy]

Hello Niko,

I do not have dbcreate database here

 

[Niko S]

What DB do you use? Oracle or MSSQL?

IF Oracle database is Dbcreate , MSSQL is dbo.check.

Please connect you APP server and find it.