Anthonio

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)

RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Hi

I am trying to use Psexec from a SQL job conneting to a other Server but its failed. It's working from command prompt (cmd)

Here the script
psexec -d \\xxxxxxx c:\PROGRA~1\ccccccc\PHASEI~2\STARTN~1.BAT
Error...

May 18, 2007 at 5:45 am

#707381
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

its defaults values. And its sorted thanks

April 23, 2007 at 6:07 am

#701907
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Good Morning

I have a VB Script below. I want to amend this script to wait for a control file. Can you please help

' VBS Script Generated by CuteFTP (TM) macro...

April 23, 2007 at 2:18 am

#701881
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Good Morning

I have a VB Script below. I want to amend this script to wait for a control file. Can you please help

' VBS Script Generated by CuteFTP (TM) macro...

April 23, 2007 at 2:17 am

#701880
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

I am receing an Error.
60118 row(s) affected)

(17904 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

,,,
0,0,0,0

(1 row(s) affected)

Server: Msg 203, Level 16, State 2, Line 239
The name...

April 19, 2007 at 12:20 am

#701332
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

I am receing an Error.
60118 row(s) affected)

(17904 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

,,,
0,0,0,0

(1 row(s) affected)

Server: Msg 203, Level 16, State 2, Line 239
The name...

April 19, 2007 at 12:19 am

#701331
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

I am receing an Error.
60118 row(s) affected)

(17904 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

(0 row(s) affected)

,,,
0,0,0,0

(1 row(s) affected)

Server: Msg 203, Level 16, State 2, Line 239
The name...

April 19, 2007 at 12:18 am

#701330
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

How do you suggest we run this Proc ?

April 4, 2007 at 6:40 am

#698511
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Hi

Nothing was modified yesterday and the only thing that was added was transaction types ( has no impact).
And we only run our Day-End (Financial Proc) at night when all...

April 3, 2007 at 9:26 am

#698330
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Hi
When I started here this Proc already existed. So I do not know what does the @v_query do

Sorry

April 3, 2007 at 9:06 am

#698322
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Hi
Just went through it now only. But I still don't know what to do ?

April 3, 2007 at 8:54 am

#698314
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Thanks,

But how do I locate the FilesInDirectory or INTERFACEFILENAMES that changed ?

April 3, 2007 at 2:58 am

#698238
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

It take's financial transactions from a Txt file and insert's it into a Table

April 3, 2007 at 1:49 am

#698231
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Sorry
It's when we start with this step below. Will this maybe help ?
DECLARE CURFINANCIALS CURSOR FOR
SELECT 'EXEC AB_FINANCIAL '''+ PATH+ ''''
FROM FilesInDirectory A
JOIN INTERFACEFILENAMES B ON A.PATH LIKE FILESTUB
AND...

April 3, 2007 at 12:59 am

#698225
RE: Could not complete cursor operation because the table schema changed after the cursor was declared. [SQLSTATE 42000] (Error 16943). The step failed.

Can you please help

April 3, 2007 at 12:33 am

#698222

Viewing 15 posts - 1 through 15 (of 16 total)