3 Replies Latest reply on Mar 12, 2018 1:11 PM by vkaufmann

    PI OLE DB Provider error

    igreguri

      I created linked table in AF (v2.9.2.8185) and I get the following error message...

       

      Connection string:

      Linked - Provider=PIOLEDB.1;User ID="";Initial Catalog=piarchive;Data Source=xxx ;Integrated Security=SSPI;Command Timeout=-1;Log Level=0;Log File="";Shorten Primary Keys=False;Always Return Rowset=False;Defer Execution=False;Identifier Prefixes=False;Disable Server Selection=False;Time as Double=False;Optimization Log Limit=100;Session ID=1;Keep Default Ordering=True;Session Pipelines=1;Current Time Precision=1;Function Errors as NULL=True;Cancel On Low Resources=True;Show Hidden Metadata=False;Schema Name="";Application Identity="";Default Timestep=1h;Integers as Value=False;Timestamp Interval Start=False;Support PI Wildcards=True;Time Zone=Local;Sync Calls=False;Connection Type=PreferPrimary;Max Cache Size=100000;Server Log="";

      OLEDB error connection.jpg

      OLEDB error.jpg

      Server log:

      Function System.String FillDataSetWithColumnDefs(Int32, OSIsoft.AF.Service.dcObjectIdentity, System.String, System.Guid, OSIsoft.AF.Service.dcTableColumnDef[], OSIsoft.AF.Service.dcServerError ByRef) at line: 0 in file System.ArgumentException: Invalid name character in 'xmlns:xs'. The ':' character, hexadecimal value 0x3A, cannot be included in a name. at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname) at System.Xml.XmlWellFormedWriter.WriteStartAttribute(String prefix, String localName, String namespaceName) at System.Data.XmlDataTreeWriter.XmlDataRowWriter(DataRow row, String encodedTableName) at System.Data.XmlDataTreeWriter.Save(XmlWriter xw, Boolean writeSchema) at System.Data.DataSet.WriteXml(XmlWriter writer, XmlWriteMode mode) at OSIsoft.AF.Service.AFService.FillDataSetCommon(CallContext callContext, String dataAdapterType, String connection, String command, Boolean impersonateUser, Byte[] encryptedPassword, dcTableColumnDef[] tableColumnDefs, dcTableParameter[] parameters, Dictionary`2 defaultParameters, dcServerError& err) dcServerError state: Operation = 0 ErrorNumber = -2 Message = Invalid name character in 'xmlns:xs'. The ':' character, hexadecimal value 0x3A, cannot be included in a name. Procedure = System.Xml ObjectType = 43 ID = 2596280f-9ad6-4b72-b5ae-4874ae7d844f ObjectName = TotalCrude SubObjectType = 0 User = Unknown LockedByUser = at System.Xml.XmlWellFormedWriter.CheckNCName(String ncname) at System.Xml.XmlWellFormedWriter.WriteStartAttribute(String prefix, String localName, String namespaceName) at System.Data.XmlDataTreeWriter.XmlDataRowWriter(DataRow row, String encodedTableName) at System.Data.XmlDataTreeWriter.Save(XmlWriter xw, Boolean writeSchema) at System.Data.DataSet.WriteXml(XmlWriter writer, XmlWriteMode mode) at OSIsoft.AF.Service.AFService.FillDataSetCommon(CallContext callContext, String dataAdapterType, String connection, String command, Boolean impersonateUser, Byte[] encryptedPassword, dcTableColumnDef[] tableColumnDefs, dcTableParameter[] parameters, Dictionary`2 defaultParameters, dcServerError& err) OtherObjectType = 0 OtherObjectName = Unknown OtherObjectID = 00000000-0000-0000-0000-000000000000

       

      Any ideas how to solve this problem (Invalid name character in 'xmlns:xs')?

      Query in PI SQL Commander works normally.