SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Oracle 8.1.6 Dr. Watson error

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
Oracle 8.1.6 Dr. Watson error
Author Message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Oracle 8.1.6 Dr. Watson error Reply with quote

I am trying to connect to a oracle 8.1.6. database and retreive data with this product (evaluation copy), from a windows NT machine. I received DR. Watson errors. Please could you help.

Tue Aug 22, 2000 3:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: Oracle 8.1.6 Dr. Watson error Reply with quote

How do you do that? (SQL job or JAL script?) Can you post your code here?
How do you connect to the database? (ODBC, native driver, async?)
How many rows/columns do you retreive from db?

Please provide more information, so we can start helping you

: I am trying to connect to a oracle 8.1.6. database and retreive data with
: this product (evaluation copy), from a windows NT machine. I received DR.
: Watson errors. Please could you help.

Tue Aug 22, 2000 4:12 pm View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle 8.1.6 Dr. Watson error Reply with quote

: How do you do that? (SQL job or JAL script?) Can you post your code here?
: How do you connect to the database? (ODBC, native driver, async?)
: How many rows/columns do you retreive from db?

: Please provide more information, so we can start helping you

The first time i run this script there is no error. If I rerun it i receive a Dr. Watson error "Access violation..."

JAL script:
// *******************************************************************
// Program: ChkCsiRj.JAL
// Description: Check rejected record for CSI and send email to constant
// recipient.
// Date: 2000-08-22
// Autor: Pierre Dupuis
//
// Modification:
// Date:
// Autor:
// *******************************************************************

// *** Constant ***

//Dim mail_recipient, string, "mtl_ecm_support_team"
Dim mail_recipient, string, "pierre_dupuis"
Dim database_name, string, "CSI Dev"
Dim sql_select,string, "select * from csi_loading_logs WHERE NVL(total_nb_records,1) != NVL(nb_rejected_records,0) AND notice_ind = 0 "
Dim sql_update,string, "update csi_loading_log set notice_ind=1 where id = "
Dim message1,string, "The number of rejected records found: "
Dim subject,string, "CSI rejected record found"

Dim rows, number
Dim str_rows, string
Dim row_updated, number
Dim result, string
Dim empty, boolean
Dim update_err, boolean
Dim ind1, number

// Connect to database
DatabaseConnect( database_name )
DatabaseRetrieve( sql_select, rows )
IsEqual( rows, 0, empty )
IfThen( empty, END )

// Get id and update notice_ind

string (rows, str_rows)

ForNext(ind1,1,rows,1,END_LOOP)

DatabaseGet ind1,1,result

Concat sql_update,result,sql_update

DatabaseExecute sql_update, row_updated

IsEqual( row_updated, 0, update_err )

If( update_err, UPDATE_ERROR, NO_ERROR )

UPDATE_ERROR:

messageBox("update error")

// Concat message1, str_rows, message1

// MailSend "", "", mail_recipient, subject, message1

NO_ERROR:

END_LOOP:

EMAIL:

// send email alert
Concat message1, str_rows, message1
// MailSend "", "", mail_recipient, subject, message1
MessageBox(message1)

goto end

END:
// Normal end
MessageBox("rien")
DatabaseDisconnect

Wed Aug 23, 2000 7:40 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7841

Post Re: Oracle 8.1.6 Dr. Watson error Reply with quote

Your code looks fine, but how do you connect to the database and run this script?
Have you tried using Oracle 7.3 driver?
Does it crash when connected via ODBC?
Is it asynchronous or synchronous script?
Is the connection asynchronous or synchronous (as specified in the database profile)?

: The first time i run this script there is no error. If I rerun it i receive a
: Dr. Watson error "Access violation..."

: JAL script: //
: *******************************************************************
: // Program: ChkCsiRj.JAL
: // Description: Check rejected record for CSI and send email to constant
: // recipient.
: // Date: 2000-08-22
: // Autor: Pierre Dupuis
: //
: // Modification: // Date: // Autor: //
: *******************************************************************

: // *** Constant ***

: //Dim mail_recipient, string, "mtl_ecm_support_team"
: Dim mail_recipient, string, "pierre_dupuis"
: Dim database_name, string, "CSI Dev"
: Dim sql_select,string, "select * from csi_loading_logs WHERE
: NVL(total_nb_records,1) != NVL(nb_rejected_records,0) AND notice_ind = 0
: "
: Dim sql_update,string, "update csi_loading_log set notice_ind=1 where id
: = "
: Dim message1,string, "The number of rejected records found: "
: Dim subject,string, "CSI rejected record found"

: Dim rows, number
: Dim str_rows, string
: Dim row_updated, number
: Dim result, string
: Dim empty, boolean
: Dim update_err, boolean
: Dim ind1, number

: // Connect to database
: DatabaseConnect( database_name )
: DatabaseRetrieve( sql_select, rows )
: IsEqual( rows, 0, empty )
: IfThen( empty, END )

: // Get id and update notice_ind

: string (rows, str_rows)

: ForNext(ind1,1,rows,1,END_LOOP)

: DatabaseGet ind1,1,result

: Concat sql_update,result,sql_update

: DatabaseExecute sql_update, row_updated

: IsEqual( row_updated, 0, update_err )

: If( update_err, UPDATE_ERROR, NO_ERROR )

: UPDATE_ERROR: messageBox("update error")

: // Concat message1, str_rows, message1

: // MailSend "", "", mail_recipient, subject, message1

: NO_ERROR: END_LOOP: EMAIL: // send email alert
: Concat message1, str_rows, message1
: // MailSend "", "", mail_recipient, subject, message1
: MessageBox(message1)

: goto end

: END: // Normal end
: MessageBox("rien")
: DatabaseDisconnect

Wed Aug 23, 2000 8:27 am View user's profile Send private message
Pierre Dupuis



Joined: 22 Aug 2000
Posts: 85

Post Re: Oracle 8.1.6 Dr. Watson error Reply with quote

: Your code looks fine, but how do you connect to the database and run this
: script?
: Have you tried using Oracle 7.3 driver?
: Does it crash when connected via ODBC?
: Is it asynchronous or synchronous script?
: Is the connection asynchronous or synchronous (as specified in the database
: profile)?

I changed the "DatabaseConnect" command to "DatabaseConnectEx" and it's work fine now. Thanks.


Wed Aug 23, 2000 1:05 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.