Just updated to the newest ORM Support classes and Oracle provider, and get this error:

(seemed to work fine with using the prior) prior (worked ok): SD.LLBLGen.Pro.DQE.OracleODPNet.NET20.dll - 3.1.11.706 - 30-Sept-2011 SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll - 3.1.11.0907 - 30-Sept-2011

new (give below error): SD.LLBLGen.Pro.DQE.OracleOPDNet.NET20.dll - 3.1.12.0716, 6-Nov-2012, SD.LLBLGen.Pro.ORMSupportClasses.NET20.dll - 3.1.12.1015 6-Nov-2012

Thoughts?

Thanks!

Program exited with error: The following exception occured at Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String, Boolean): ORA-01741: illegal zero-length identifier

The following exception occured at System.Data.Common.DbDataReader Execute(System.Data.CommandBehavior): An exception was caught during the execution of a retrieval query: ORA-01741: illegal zero-length identifier. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

The following exception occured at Grb.Framework.Business.Lower.EntityClasses.SystemEntity GetSystemEntity(SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): SystemManager_GetSystemEntity

The following exception occured at Grb.Framework.Business.Lower.EntityClasses.SystemEntity GetSystemEntity(): SystemManager_GetSystemEntity

The following exception occured at Grb.Framework.Business.Lower.EntityClasses.SystemEntity GetSystemEntity(): SystemManager_GetSystemEntity

The following exception occured at System.Version get_DatabaseVersion(): SystemManager_DatabaseVersion

The following exception occured at Void CheckForCompatibleProductAndDatabaseVersions(): SystemManager_CheckForCompatibleProductAndDatabaseVersions

Stack Trace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at 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:line 112 at 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:line 132 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:line 602 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:line 4575 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, Program exited with error: The following exception occured at Void HandleErrorHelper(Int32, Oracle.DataAccess.Client.OracleConnection, IntPtr, Oracle.DataAccess.Client.OpoSqlValCtx*, System.Object, System.String, Boolean): ORA-01741: illegal zero-length identifier

The following exception occured at System.Data.Common.DbDataReader Execute(System.Data.CommandBehavior): An exception was caught during the execution of a retrieval query: ORA-01741: illegal zero-length identifier. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.

The following exception occured at Xxx.Framework.Business.Lower.EntityClasses.SystemEntity GetSystemEntity(SD.LLBLGen.Pro.ORMSupportClasses.IDataAccessAdapter): SystemManager_GetSystemEntity

The following exception occured at Xxx.Framework.Business.Lower.EntityClasses.SystemEntity GetSystemEntity(): SystemManager_GetSystemEntity

The following exception occured at Xxx.Framework.Business.Lower.EntityClasses.SystemEntity GetSystemEntity(): SystemManager_GetSystemEntity

The following exception occured at System.Version get_DatabaseVersion(): SystemManager_DatabaseVersion

The following exception occured at Void CheckForCompatibleProductAndDatabaseVersions(): SystemManager_CheckForCompatibleProductAndDatabaseVersions

Stack Trace: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck) at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck) at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior) at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at 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:line 112 at 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:line 132 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.ExecuteMultiRowRetrievalQuery(IRetrievalQuery queryToExecute, IEntityFactory2 entityFactory, IEntityCollection2 collectionToFill, IFieldPersistenceInfo[] fieldsPersistenceInfo, Boolean allowDuplicates, IEntityFields2 fieldsUsedForQuery) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:line 602 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollectionInternal(IEntityCollection2 collectionToFill, IRelationPredicateBucket& filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:line 4575 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket, Int32 maxNumberOfItemsToReturn, ISortExpression sortClauses, IPrefetchPath2 prefetchPath, ExcludeIncludeFieldsList excludedIncludedFields, Int32 pageNumber, Int32 pageSize) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:line 2461 at SD.LLBLGen.Pro.ORMSupportClasses.DataAccessAdapterBase.FetchEntityCollection(IEntityCollection2 collectionToFill, IRelationPredicateBucket filterBucket) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v3.1\Frameworks\LLBLGen Pro\RuntimeLibraries\ORMSupportClasses\AdapterSpecific\DataAccessAdapterBase.cs:line 2271 at Xxx.Framework.Business.SystemManager.GetSystemEntity(IDataAccessAdapter externalAdapter) in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 203 at Xxx.Framework.Business.SystemManager.GetSystemEntity(IDataAccessAdapter externalAdapter) in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 223 at Xxx.Framework.Business.SystemManager.GetSystemEntity() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 176 at Xxx.Framework.Business.SystemManager.GetSystemEntity() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 179 at Xxx.Framework.Business.SystemManager.GetSystemEntity() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 186 at Xxx.Framework.Business.SystemManager.get_DatabaseVersion() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 51 at Xxx.Framework.Business.SystemManager.get_DatabaseVersion() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 58 at Xxx.Framework.Business.SystemManager.CheckForCompatibleProductAndDatabaseVersions() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 344 at Xxx.Framework.Business.SystemManager.CheckForCompatibleProductAndDatabaseVersions() in C:\source\production\ProductWeb\Framework\Business\SystemManager.vb:line 359 at Import.Main.Main() in C:\source\production\ProductWeb\Utilities\Product\ProductWebImport\Main.vb:line 328.

Could you enable tracing (see 'troubleshooting and debugging') and confirm it's the same issue as this: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=21169

?

It's odd this is still in the framework, as we fixed it some time ago. We'll try to reproduce it as well.

I can't reproduce it with the latest build (4-12-12, not released yet). Looking at the change logs, I can't see something that changed behavior after the build you got.

Please make absolutely sure you updated both the orm support classes AND the oracle DQE dll, as the fix was in the oracle DQE dll. Fix was made last July.

Hi Otis,

Thanks for looking into this. I cleared all directories on my machine and repulled from source control (includes the llblgen .dlls), and it doesn't give me this error any more. I'm still scratching my head of what wrong file I had in which location...

Thanks for your help!

Merry christmas