Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9.2.x -> SD SP5 data export

Highlighted
Andrej Saje_1
Super Collector

Oracle 9.2.x -> SD SP5 data export

Hello,

when trying to export CIs from OVOUX 7.x on Oracle database with ECW I encountered the following error as attached. A default ovounixci.ini has been used. Any idea?

Thanks,

Andrej
5 REPLIES
Alejandro_30
Regular Collector

Re: Oracle 9.2.x -> SD SP5 data export


I have this problem with OVOux 8.1 and S.D 4.5 with service pack 12 and oracle 9.2.0.1
any sugestions ??'

Alejandro_30
Regular Collector

Re: Oracle 9.2.x -> SD SP5 data export

any sugest with this !!!!!!!!!
Andrej Saje_1
Super Collector

Re: Oracle 9.2.x -> SD SP5 data export

Alejandro,

the issue here is related with sql commands somehow. So, the right sql syntax should be used for this to work, but do not ask me which. You can try to execute the sql statement directly on the oracle sd database via native sql query.

Andrej
Jasper Verweij
Honored Contributor

Re: Oracle 9.2.x -> SD SP5 data export

This errors mostly indicates wrong formatted SQL syntax.

Possible causes:
- \ not properly used as end-of-line character
- , forgotten
- ) forgotten somewhere

You could use Toad (freeware version could be downloaded from http://www.toadsoft.com ) to paste the SQL syntax and run it and get a clue where the syntax is wrong.

If I read the export log correctly something goes wrong at the part of
mod([ip_address]' AS , '256)' AS "ip_address"
(backslashes wrong???)

Jasper

Re: Oracle 9.2.x -> SD SP5 data export

Hi We are seeing this with DS 4.5 SP9 - has anyone come up with a solution by now ?
//Add this to "OnDomLoad" event