SQL0104N An unexpected token """" was found following "SELECT "

Posts   
 
    
dazedorconfused avatar
Posts: 89
Joined: 06-Apr-2006
# Posted on: 10-Oct-2012 15:47:24   

I am using LLBLGen Pro 3.1 to create a Self Service LLBLGen Pro Framework Project in C# Targeting .Net Framework. The database is DB2 9.7 on 64 bit AIX. Actually, its been working for years. Yesterday, I deployed a build (with no changes to my persistence layer) to my QA server and I started receiving this error. I pointed my development environment at the production DB2 server (don't tell the DBA) and verified that I receive the same error.

ERROR [42601] [IBM][DB2/AIX64] SQL0104N  An unexpected token """" was found following "SELECT ".  Expected tokens may include:  "<space>".  SQLSTATE=42601

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: IBM.Data.DB2.DB2Exception: ERROR [42601] [IBM][DB2/AIX64] SQL0104N  An unexpected token """" was found following "SELECT ".  Expected tokens may include:  "<space>".  SQLSTATE=42601


Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[DB2Exception (0x80004005): ERROR [42601] [IBM][DB2/AIX64] SQL0104N  An unexpected token """" was found following "SELECT ".  Expected tokens may include:  "<space>".  SQLSTATE=42601
]
   IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation) +2378
   IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method) +22
   IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior) +133
   IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior) +4
   System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) +10
   SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\RetrievalQuery.cs:94

[ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: ERROR [42601] [IBM][DB2/AIX64] SQL0104N  An unexpected token """" was found following "SELECT ".  Expected tokens may include:  "<space>".  SQLSTATE=42601
. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.]
   SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\Query\RetrievalQuery.cs:132
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformExecuteSingleRowRetrievalQuery(IRetrievalQuery queryToExecute, CommandBehavior behavior) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\SelfServicingSpecific\DaoBase.cs:2234
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.ExecuteSingleRowRetrievalQuery(IRetrievalQuery queryToExecute, ITransaction containingTransaction, IEntityFields fieldsToFill, IFieldPersistenceInfo[] fieldPersistenceInfos) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\SelfServicingSpecific\DaoBase.cs:1475
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformFetchEntityAction(IEntity entityToFetch, ITransaction containingTransaction, IPredicateExpression selectFilter, IPrefetchPath prefetchPathToUse, Context contextToUse, ExcludeIncludeFieldsList excludedIncludedFields) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\SelfServicingSpecific\DaoBase.cs:292
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.FetchExisting(IEntity entityToFetch, ITransaction containingTransaction, IPrefetchPath prefetchPathToUse, Context contextToUse, ExcludeIncludeFieldsList excludedIncludedFields) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\SelfServicingSpecific\DaoBase.cs:131
   com.cooperlighting.persistence.flash.EntityClasses.SalesInstrumentEntity.Fetch(String uid, IPrefetchPath prefetchPathToUse, Context contextToUse, ExcludeIncludeFieldsList excludedIncludedFields) in C:\Dev\Submittals\src\com\cooperlighting\drawingsandsubmittals\persistence\flash\EntityClasses\SalesInstrumentEntity.cs:735
   com.cooperlighting.persistence.flash.EntityClasses.SalesInstrumentEntity.InitClassFetch(String uid, IValidator validator, IPrefetchPath prefetchPathToUse) in C:\Dev\Submittals\src\com\cooperlighting\drawingsandsubmittals\persistence\flash\EntityClasses\SalesInstrumentEntity.cs:526
   com.cooperlighting.persistence.flash.EntityClasses.SalesInstrumentEntity..ctor(String uid) in C:\Dev\Submittals\src\com\cooperlighting\drawingsandsubmittals\persistence\flash\EntityClasses\SalesInstrumentEntity.cs:82
   com.cooperlighting.persistence.flash.EntityClasses.OrderEntity..ctor(String uid) in C:\Dev\Submittals\src\com\cooperlighting\drawingsandsubmittals\persistence\flash\EntityClasses\OrderEntity.cs:100
   com.cooperlighting.submittals.services.DB2Test.Page_Load(Object sender, EventArgs e) in C:\Dev\Submittals\src\com\cooperlighting\drawingsandsubmittals\services\DrawingServices\DB2Test.aspx.cs:20
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

In looking at the generated SQL, I see the following (notice the double double quotes surrounding SC):


Generated Sql query: 
    Query: SELECT ""SC""."CLSALESINSTRUMENT"."ACTIVE" AS "Active", ""SC""."CLSALESINSTRUMENT"."AGENTCONTACT" AS "Agentcontact", ""SC""."CLSALESINSTRUMENT"."APPLICATION" AS "Application", ""SC""."CLSALESINSTRUMENT"."APPROVALSTATCODE" AS "Approvalstatcode", ""SC""."CLSALESINSTRUMENT"."AUTOAPPROVAL" AS "Autoapproval", ""SC""."CLSALESINSTRUMENT"."BIGCOMMENTS" AS "Bigcomments", ""SC""."CLSALESINSTRUMENT"."CFNATIONALACCOUNT" AS "Cfnationalaccount", ""SC""."CLSALESINSTRUMENT"."CFPONUMBER" AS "Cfponumber", ""SC""."CLSALESINSTRUMENT"."CHANNEL" AS "Channel", ""SC""."CLSALESINSTRUMENT"."COMMAGENTS" AS "Commagents", ""SC""."CLSALESINSTRUMENT"."COMMSALESPERSONS" AS "Commsalespersons", ""SC""."CLSALESINSTRUMENT"."COUNTRYCODE" AS "Countrycode", ""SC""."CLSALESINSTRUMENT"."CREATEDBY" AS "CreatedbyUid", ""SC""."CLSALESINSTRUMENT"."CREATIONDATE" AS "Creationdate", ""SC""."CLSALESINSTRUMENT"."CURRENCY" AS "Currency", ""SC""."CLSALESINSTRUMENT"."CURRENCYCODE" AS "Currencycode", ""SC""."CLSALESINSTRUMENT"."DAMAGEREPLACEMENT" AS "Damagereplacement", ""SC""."CLSALESINSTRUMENT"."DGUPDATEDATE" AS "Dgupdatedate", ""SC""."CLSALESINSTRUMENT"."DIVISION" AS "Division", ""SC""."CLSALESINSTRUMENT"."DRAWINGGENERATED" AS "Drawinggenerated", ""SC""."CLSALESINSTRUMENT"."DUEDATE" AS "Duedate", ""SC""."CLSALESINSTRUMENT"."DUEDATESTATUS" AS "Duedatestatus", ""SC""."CLSALESINSTRUMENT"."ERFNUMBER" AS "Erfnumber", ""SC""."CLSALESINSTRUMENT"."EXPIRATION" AS "Expiration", ""SC""."CLSALESINSTRUMENT"."GROUPBYBRAND" AS "Groupbybrand", ""SC""."CLSALESINSTRUMENT"."GROUPBYGROUPCODE" AS "Groupbygroupcode", ""SC""."CLSALESINSTRUMENT"."GROUPBYLINEDESIGN" AS "Groupbylinedesign", ""SC""."CLSALESINSTRUMENT"."GROUPBYMFR" AS "Groupbymfr", ""SC""."CLSALESINSTRUMENT"."GROUPBYTYPE" AS "Groupbytype", ""SC""."CLSALESINSTRUMENT"."ISAI" AS "Isai", ""SC""."CLSALESINSTRUMENT"."ISFAXED" AS "Isfaxed", ""SC""."CLSALESINSTRUMENT"."ISTEMPLATE" AS "Istemplate", ""SC""."CLSALESINSTRUMENT"."LATEFAXREASON" AS "Latefaxreason", ""SC""."CLSALESINSTRUMENT"."LEADTIME" AS "Leadtime", ""SC""."CLSALESINSTRUMENT"."LINEITEMS" AS "LineitemCollectionGid", ""SC""."CLSALESINSTRUMENT"."MODIFICATIONDATE" AS "Modificationdate", ""SC""."CLSALESINSTRUMENT"."MODIFIEDBY" AS "Modifiedby", ""SC""."CLSALESINSTRUMENT"."MTGHWDATE" AS "Mtghwdate", ""SC""."CLSALESINSTRUMENT"."ORGFAXDATE" AS "Orgfaxdate", ""SC""."CLSALESINSTRUMENT"."PACKAGEGENERATED" AS "Packagegenerated", ""SC""."CLSALESINSTRUMENT"."PGUPDATEDATE" AS "Pgupdatedate", ""SC""."CLSALESINSTRUMENT"."PHAAPPROVAL" AS "Phaapproval", ""SC""."CLSALESINSTRUMENT"."PHACOMPLETE" AS "Phacomplete", ""SC""."CLSALESINSTRUMENT"."PRICEGUIDETOTALS" AS "Priceguidetotals", ""SC""."CLSALESINSTRUMENT"."PRICELASTAPPRVDBY" AS "Pricelastapprvdby", ""SC""."CLSALESINSTRUMENT"."PRICETOTALS" AS "Pricetotals", ""SC""."CLSALESINSTRUMENT"."PRICINGCODE" AS "Pricingcode", ""SC""."CLSALESINSTRUMENT"."PRODLASTAPPRVDBY" AS "Prodlastapprvdby", ""SC""."CLSALESINSTRUMENT"."PSUPDATEDATE" AS "Psupdatedate", ""SC""."CLSALESINSTRUMENT"."PSUSER" AS "Psuser", ""SC""."CLSALESINSTRUMENT"."QSSRUPDATEDATE" AS "Qssrupdatedate", ""SC""."CLSALESINSTRUMENT"."QSSRUSER" AS "Qssruser", ""SC""."CLSALESINSTRUMENT"."REPLICATE" AS "Replicate", ""SC""."CLSALESINSTRUMENT"."REQUESTEDDATE" AS "Requesteddate", ""SC""."CLSALESINSTRUMENT"."SALESGROUP" AS "Salesgroup", ""SC""."CLSALESINSTRUMENT"."SALESOFFICE" AS "Salesoffice", ""SC""."CLSALESINSTRUMENT"."SALESORGANIZATION" AS "SalesorganizationId", ""SC""."CLSALESINSTRUMENT"."SENDTO" AS "Sendto", ""SC""."CLSALESINSTRUMENT"."SIGNATURE" AS "Signature", ""SC""."CLSALESINSTRUMENT"."SIGNATUREDATE" AS "Signaturedate", ""SC""."CLSALESINSTRUMENT"."SPLHANDLINGCODE" AS "Splhandlingcode", ""SC""."CLSALESINSTRUMENT"."SUBMITTALDATE" AS "Submittaldate", ""SC""."CLSALESINSTRUMENT"."TRIL_GID" AS "Uid_SalesInstrumentEntity", ""SC""."CLSALESINSTRUMENT"."UPDATEABLEBY" AS "Updateableby", ""SC""."CLSALESINSTRUMENT"."XFERFLAG" AS "Xferflag", ""SC""."CLORDER"."TRIL_GID" AS "Uid", ""SC""."CLORDER"."ACKNOWLEDGEMENTS" AS "Acknowledgements", ""SC""."CLORDER"."ADDRCHGREQSTATUS" AS "Addrchgreqstatus", ""SC""."CLORDER"."AGENT" AS "AgentUid", ""SC""."CLORDER"."ALTERNATEADDRESS" AS "AlternateAddressUid", ""SC""."CLORDER"."ALTERNATENAME1" AS "Alternatename1", ""SC""."CLORDER"."ALTERNATENAME2" AS "Alternatename2", ""SC""."CLORDER"."APRVLSTATUSCODE" AS "Aprvlstatuscode", ""SC""."CLORDER"."CANADIANPST" AS "Canadianpst", ""SC""."CLORDER"."CANCELBACKORDER" AS "Cancelbackorder", ""SC""."CLORDER"."CANCELBYDATE" AS "Cancelbydate", ""SC""."CLORDER"."CANREMSNAPSHOT" AS "Canremsnapshot", ""SC""."CLORDER"."CARRIERID" AS "Carrierid", ""SC""."CLORDER"."CHANGEDORDTOTAL" AS "Changedordtotal", ""SC""."CLORDER"."CHANGEREQSTATUS" AS "Changereqstatus", ""SC""."CLORDER"."CNATIONALACCOUNT" AS "CnationalaccountUid", ""SC""."CLORDER"."COOPERORDERNUMBER" AS "Cooperordernumber", ""SC""."CLORDER"."COOPERQUOTENUMBER" AS "Cooperquotenumber", ""SC""."CLORDER"."CREATEDATETIME" AS "Createdatetime", ""SC""."CLORDER"."CREATEUSER" AS "CreateuserUid", ""SC""."CLORDER"."CREDITVERIFNUMBER" AS "Creditverifnumber", ""SC""."CLORDER"."CUSTOMERTOTALAMT" AS "Customertotalamt", ""SC""."CLORDER"."DELIVERYCONTACT" AS "Deliverycontact", ""SC""."CLORDER"."DELIVERYCONTACTPH" AS "Deliverycontactph", ""SC""."CLORDER"."DISTCONTACT" AS "Distcontact", ""SC""."CLORDER"."DISTRIBUTOR" AS "DistributorUid", ""SC""."CLORDER"."DODGENUMBER" AS "Dodgenumber", ""SC""."CLORDER"."DONOTSHPBEFSHPDTE" AS "Donotshpbefshpdte", ""SC""."CLORDER"."EMAIL_1" AS "Email1", ""SC""."CLORDER"."EMAIL_2" AS "Email2", ""SC""."CLORDER"."FACTCOMMITDATE" AS "Factcommitdate", ""SC""."CLORDER"."FAXIMAGE" AS "Faximage", ""SC""."CLORDER"."FAXPATH" AS "Faxpath", ""SC""."CLORDER"."FREIGHTACCOUNT" AS "Freightaccount", ""SC""."CLORDER"."FREIGHTTERMOVRRIDE" AS "Freighttermovrride", ""SC""."CLORDER"."GLCODE" AS "Glcode", ""SC""."CLORDER"."HOLDFORREL" AS "Holdforrel", ""SC""."CLORDER"."ISACTIVE" AS "Isactive", ""SC""."CLORDER"."ISSNPCRYBYAGENT" AS "Issnpcrybyagent", ""SC""."CLORDER"."LASTACKNUMBER" AS "Lastacknumber", ""SC""."CLORDER"."LOSTOPPYCMNTS" AS "Lostoppycmnts", ""SC""."CLORDER"."LOTINVOICED" AS "Lotinvoiced", ""SC""."CLORDER"."LOTPRICED" AS "Lotpriced", ""SC""."CLORDER"."MANUFACTURER" AS "Manufacturer", ""SC""."CLORDER"."MISCCHARGE" AS "Misccharge", ""SC""."CLORDER"."MISCCHARGECODE" AS "MiscchargecodeUid", ""SC""."CLORDER"."MODIFIEDDATETIME" AS "Modifieddatetime", ""SC""."CLORDER"."MODIFIEDUSER" AS "ModifieduserUid", ""SC""."CLORDER"."NATIONALACCOUNT" AS "NationalaccountUid", ""SC""."CLORDER"."ORDERCOMMENTS" AS "OrdercommentsUid", ""SC""."CLORDER"."ORDERCUDCODE" AS "Ordercudcode", ""SC""."CLORDER"."ORDERNUMBER" AS "Ordernumber", ""SC""."CLORDER"."ORDERREVISION" AS "Orderrevision", ""SC""."CLORDER"."ORDERSNAPSHOT" AS "OrdersnapshotUid", ""SC""."CLORDER"."ORDERSOURCE" AS "Ordersource", ""SC""."CLORDER"."ORDERSTATUSCODE" AS "Orderstatuscode", ""SC""."CLORDER"."ORDERSTATUSDATE" AS "Orderstatusdate", ""SC""."CLORDER"."ORDERTYPECODE" AS "Ordertypecode", ""SC""."CLORDER"."ORDTOTCHGRQSTAT" AS "Ordtotchgrqstat", ""SC""."CLORDER"."PODATE" AS "Podate", ""SC""."CLORDER"."PONUMBER" AS "Ponumber", ""SC""."CLORDER"."PRICETOTAL1" AS "Pricetotal1Uid", ""SC""."CLORDER"."PROJECTCITY" AS "Projectcity", ""SC""."CLORDER"."PROJECTCOUNTRY" AS "Projectcountry", ""SC""."CLORDER"."PROJECTNAME" AS "Projectname", ""SC""."CLORDER"."PROJECTNUMBER" AS "Projectnumber", ""SC""."CLORDER"."PROJECTSTATECODE" AS "Projectstatecode", ""SC""."CLORDER"."PROMOCHGREQSTATUS" AS "Promochgreqstatus", ""SC""."CLORDER"."PROMOTION" AS "PromotionUid", ""SC""."CLORDER"."QUOTENUMBER" AS "Quotenumber", ""SC""."CLORDER"."QUOTE" AS "QuoteUid", ""SC""."CLORDER"."RQSTDDELIVERYDATE" AS "Rqstddeliverydate", ""SC""."CLORDER"."RQSTDSHIPDATE" AS "Rqstdshipdate", ""SC""."CLORDER"."SAPIDOCNUMBER" AS "Sapidocnumber", ""SC""."CLORDER"."SAPORDERNUMBER" AS "Sapordernumber", ""SC""."CLORDER"."SAPTRANSACTIONID" AS "Saptransactionid", ""SC""."CLORDER"."SENTTOCOPS" AS "Senttocops", ""SC""."CLORDER"."SENTTOSAP" AS "Senttosap", ""SC""."CLORDER"."SHIPALLTOGETHER" AS "Shipalltogether", ""SC""."CLORDER"."SHIPCHGRQSTATUS" AS "Shipchgrqstatus", ""SC""."CLORDER"."SHIPCOMPLETEONLY" AS "Shipcompleteonly", ""SC""."CLORDER"."SHIPDTCHGRQSTATUS" AS "Shipdtchgrqstatus", ""SC""."CLORDER"."SHIPFROM" AS "ShipfromUid", ""SC""."CLORDER"."SHIPPINGCONDITION" AS "Shippingcondition", ""SC""."CLORDER"."SHIPPINGMETHOD" AS "ShippingmethodUid", ""SC""."CLORDER"."SHIPTOADDRESS" AS "ShiptoaddressUid", ""SC""."CLORDER"."SHIPTONAME1" AS "Shiptoname1", ""SC""."CLORDER"."SHIPTONAME2" AS "Shiptoname2", ""SC""."CLORDER"."SHIPTOSELCODE" AS "Shiptoselcode", ""SC""."CLORDER"."SHOWPRICES" AS "Showprices", ""SC""."CLORDER"."SPECIALCREDITTERM" AS "SpecialcredittermUid", ""SC""."CLORDER"."SPECNUMBER" AS "Specnumber", ""SC""."CLORDER"."SPLCONSIDERATIONS" AS "Splconsiderations", ""SC""."CLORDER"."SUBMISSIONDATE" AS "Submissiondate", ""SC""."CLORDER"."TERRITORY" AS "TerritoryUid", ""SC""."CLORDER"."THIRDPARTYACCOUNT" AS "Thirdpartyaccount", ""SC""."CLORDER"."THIRDPARTYADDRESS" AS "ThirdpartyaddressUid", ""SC""."CLORDER"."THIRDPARTYCONTACT" AS "Thirdpartycontact", ""SC""."CLORDER"."THIRDPARTYNAME" AS "Thirdpartyname", ""SC""."CLORDER"."THIRDPARTYPHONENO" AS "Thirdpartyphoneno", ""SC""."CLORDER"."TRANFROMHFRTOCO" AS "Tranfromhfrtoco", ""SC""."CLORDER"."USTAXPERCENT" AS "Ustaxpercent" FROM ( ""SC""."CLSALESINSTRUMENT"  INNER JOIN ""SC""."CLORDER"  ON  ""SC""."CLSALESINSTRUMENT"."TRIL_GID"=""SC""."CLORDER"."TRIL_GID") WHERE ( ( ""SC""."CLSALESINSTRUMENT"."TRIL_GID" = ?) AND ( ""SC""."CLORDER"."TRIL_GID" IS NOT NULL))
    Parameter: @p1 : String. Length: 34. Precision: 0. Scale: 0. Direction: Input. Value: "DVOGGGR41X0EZDRWM4Z5MCG4XVZZB0BO".

If I take the SQL above and run it in the CLI environment, I get a similar error. If I remove the doubled up double quotes, the query executes. *

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 11-Oct-2012 03:47:46   

Hi Steven,

Please provide the exact runtime library version (http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=7717), or better, update to the latest v3.1 build and check that you are referencing the correct assemblies.

Also, if it works on your dev machine, then something changed on the DB server, investigate further on this.

David Elizondo | LLBLGen Support Team
dazedorconfused avatar
Posts: 89
Joined: 06-Apr-2006
# Posted on: 11-Oct-2012 14:30:08   

Regarding my runtime environment: SD.LLBLGen.Pro.DQE.DB2.NET20.dll v2.5.7.820 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll v2.5.8.1012 IBM.Data.DB2.dll v9.7.0.2 IBM.Data.DB2.9.7.0.dll v9.7.0.2

Also, if it works on your dev machine, then something changed on the DB server, investigate further on this.

I believe you misunderstood my original post. Regardless of what database I point to, I am getting this error. I get it running in debug mode, pointed to both my QA and Prod DB2 Servers. And I also get it if I compile my code and deploy it to the QA server.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 11-Oct-2012 21:51:48   

I'm confused. In your first post you say you are using v.3.1 But in your last post you report v.2.5

Which of them are you using?

Btw, there was a similar issue solved 2 months ago on v.3.x http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=21192

dazedorconfused avatar
Posts: 89
Joined: 06-Apr-2006
# Posted on: 11-Oct-2012 22:08:43   

I am using LLBLGenPro Version 3.1 Final, Released on March 12th, 2012.

David inquired as to my runtime version to which I posted the version of ever applicable runtime dll. I got the version numbers by right clicking on the dll, going to properties then selecting the details tab.

Have I done something wrong? Am I missing any more pertinent information.

Thanks.

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 11-Oct-2012 22:18:41   

SD.LLBLGen.Pro.DQE.DB2.NET20.dll v2.5.7.820 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll v2.5.8.1012

The version numbers of the runtime libraries indicate you are using v.2.5

dazedorconfused avatar
Posts: 89
Joined: 06-Apr-2006
# Posted on: 11-Oct-2012 23:20:01   

I am sorry for the confusion I was looking in tthe wrong place.

SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll is version 3.1.12.716 SD.LLBLGen.Pro.DQE.SqlServer.NET20.dll is version 3.1.11.706

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 12-Oct-2012 11:03:18   

Then as per my previous post, please download the latest build, of v.3.1. And check this out again. As there was a fix of a similar issue in August and your runtimes are from July.

dazedorconfused avatar
Posts: 89
Joined: 06-Apr-2006
# Posted on: 12-Oct-2012 15:55:04   

Is there any reason I shouldn't just upgrade to 3.5?

dazedorconfused avatar
Posts: 89
Joined: 06-Apr-2006
# Posted on: 12-Oct-2012 19:49:09   

I upgraded to 3.5 and the error is gone. Thank you for you help.