Archives of the TeradataForum

Message Posted: Thu, 11 Dec 2003 @ 09:11:53 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, December 10, 2003 18:00 -->

We have a problem with a new installation of TDAT32.DLL. Hopefully someone knows what the problem is, and can get me on the right track to fix it...

Here is our execute command (C++ Source):

rc = SQLExecDirect(Hstmt,szSqlStr, cbSqlStr);

Here are the values in the variables:

        Hstmt   0x007f1b48
-       szSqlStr        0x0006fd68 "EXEC LOGNPPROC      (?,?,?,?,?,?,?)"
                69 'E'
        cbSqlStr        -3

Here is the DDL for the macro:

REPLACE MACRO  LOGNPPROC (

     PROCESSID  SMALLINT  FORMAT '9999' NOT NULL,
     PROCESS    CHAR (48) NOT NULL,
     RUNCD      BYTEINT  FORMAT '99' NOT NULL,
     PRIMTBL    CHAR (12),
     DFPIPECD   CHAR (1),
     PRIMTPLCNT INTEGER FORMAT '9999999999',
     CMTS       CHAR (64)
)
AS
(
BEGIN TRANSACTION
;
    INSERT INTO NPPROCLG (
   ACTDATE,
   ACTTIME,
   USERID,
   PROCESSID,
   PROCESS,
   RUNCD,
   PRIMTBL,
   DFPIPECD,
   PRIMTPLCNT,
   CMTS)
VALUES (DATE,
         TIME,
         USER,
        :PROCESSID,
       :PROCESS,
       :RUNCD,
       :PRIMTBL,
       :DFPIPECD,
       :PRIMTPLCNT,
       :CMTS)
    ;
    END TRANSACTION
    ;

)
;

These are the values entered in to the table after execution with the old driver:

03/12/10  16:00:00  NPSUPER     1710  Open NP Business  01      P
0000000000      Starting

When this is run using the old driver (V 2.06.00.03) it runs fine. When run with the new driver (V 3.02.00.00) it gives the following error:

Unhandled exception in INITNPGL.EXE (TDAT32.DLL): 0xc0000005: Access Violation

Any ideas????

	<Prev	Next>		<<First	<Prev	Next>	Last>>