Post reply

Error: The OLE DB provider "SQLNCLI11" for linked server "HELIXDB" supplied inconsistent metadata for a column. The name was changed at execution time.

  • July 14, 2014 at 11:12 pm

    #293290

    Hi

    While trying to run the sql job folowing error is displaying sometimes, but the job is successfully executing some times.

    JOB:

    Step 1: SQL Script

    Step 2: SSAS package

    Executed as user: NT AUTHORITY\NETWORK SERVICE. Warning: Null value is eliminated by an aggregate or other SET operation. [SQLSTATE 01003] (Message 8153) The OLE DB provider "SQLNCLI11" for linked server "HELIXDB" supplied inconsistent metadata for a column. The name was changed at execution time. [SQLSTATE 42000] (Error 7355) 1 [SQLSTATE 01000] (Error 0) Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself. [SQLSTATE 01000] (Error 4624). The step failed.

    Regards,

    Karthik.

  • July 30, 2014 at 9:39 am

    #1733678

    Check the sql provider, you are using SQLINCL11 try using "SQL Server Native Clienct 10.0" and see if it works. I have ran into that message before and that's how I fixed it.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply