;)
;)
;)
Ananth Balasubramanyam wrote:
Status 'Transaction Failed' indicates that authentication was successful. I guess there is something wrong with the transaction piece.
Can you verify if the following point to the corressponding tables?
<sourceCode>123</sourceCode> should refer to lookup_ticketsource (code)
<catCode>1</catCode>
<subCat1>2</subCat1>
<subCat2>3</subCat2>
<subCat3>4</subCat3>
should all refer to ticket_category(id)
<enteredBy>1</enteredBy>
<modifiedBy>1</modifiedBy>
should both refer to access(user_id)
Hi Ananth
Good news! :-)
This transaction works:
$xmlDocument='<?xml version="1.0" encoding="utf-8"?>
<app>
<authentication>
<id>contatti.abd.it</id>
xxxx
<systemId>4</systemId>
<clientId>2</clientId>
</authentication>
<meta>
<property>id</property>
</meta>
<transaction id="1">
<ticket action="insert">
<problem>questo essere un ticket</problem>
<enteredBy>1</enteredBy>
<modifiedBy>1</modifiedBy>
<sourceCode>3</sourceCode>
</ticket>
</transaction>
</app>
Where "3" is my ID value for "Web" label from the "lookupticket_source" table.
I've removed the category stuff to semplify and it works..
BUT...
only in the Postgres version.
Tha same transaction with the MSSQL does not work.
The error in MSSQL case is the same:
<?xml version="1.0" encoding="UTF-8"?>
<aspcfs>
<response>
<status>1</status>
<errorText>Error: rollback() should not be called while in auto-commit mode.</errorText>
</response>
</aspcfs>
I think there is a problem (bug) with MSSQL
Hope this can help.
Now i need to know where in documentation i can find the whole list of object i can edit with xml http, the properties and the admitted values for them :-)
I'm specially interested in the syntax to populate custom folders for customer to integrate external information systems with Centric (financial information about customer, for example).
Thank You very much