anonymous Log in
DB2 for iSeries DataStore?
25/11/14 17:38


Replies: 4

Can I make the Default Data Store for my KB (.net Environment) (default Generator of (C# Web)) be DB2 for iSeries?

I know the default always comes up as SQL Server. I do not need to use any tables from an SQL Server.

I can configure a connection using the DB2 for iSeries data store, Run Developer menu.

When I select my application to run it for testing I get the following:

Keyword not supported: 'librarylist'.
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: System.ArgumentException: Keyword not supported: 'librarylist'.

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:

[ArgumentException: Keyword not supported: 'librarylist'.]
GeneXus.Data.ADO.GxConnection.Open() +1093
GeneXus.Data.ADO.GxConnectionManager.IncOpenHandles(Int32 handle, String dataSource) +223
GeneXus.Data.GxDataReader..ctor(IGxConnectionManager connManager, GxDataRecord dr, IGxConnection connection, GxParameterCollection parameters, String stmt, Int32 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean dynStmt) +231
GeneXus.Data.GxSqlServer.GetDataReader(IGxConnectionManager connManager, IGxConnection con, GxParameterCollection parameters, String stmt, UInt16 fetchSize, Boolean forFirst, Int32 handle, Boolean cached, SlidingTime expiration, Boolean hasNested, Boolean dynStmt) +416
GeneXus.Data.ADO.GxCommand.ExecuteReader() +1426

[GxADODataException: Keyword not supported: 'librarylist'.]
GeneXus.Data.ADO.GxCommand.ExecuteReader() +1648
GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +160

[GxADODataException: Keyword not supported: 'librarylist'.Keyword not supported: 'librarylist'.]
GeneXus.Data.ADO.GxCommand.FetchData(IDataReader& dr) +860
GeneXus.Data.NTier.ADO.ForEachCursor.execute() +221
GeneXus.Data.NTier.DataStoreProvider.execute(Int32 cursor, Object[] parms, Boolean batch) +1031
GeneXus.Programs.getuserinfo.executePrivate() +1331
GeneXus.Programs.getuserinfo.execute(String& aP0 id, String& aP1 idtype, String& aP2 idemail, String& aP3 FullName, String& aP4 logduserS) +148
GeneXus.Programs.martinsbrosmasterpage.E11082() +121
GeneXus.Programs.martinsbrosmasterpage.STRUP080() +70
GeneXus.Programs.martinsbrosmasterpage.START082() +188
GeneXus.Programs.martinsbrosmasterpage.webExecute() +163
GeneXus.Programs.achgroupmaintenance1.webExecute() +367
GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +397

[Exception: GXApplication exception]
GeneXus.Http.GXHttpHandler.ProcessRequest(HttpContext httpContext) +640
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +599
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +171

I'm not sure what to do from this point.
Thanks, Tammy Scott


25/11/14 17:53
Tammy, you can Change the DBMS of the Data Store by righ-clicking on the data store. Like this: After changing the DBMS please check the data store properties again in order to set them appropiately. Regards, Armin​ On Tue, Nov 25, 2014 at 4:22 PM, Tammy Scott


25/11/14 18:02
Thank you but, I have done this already. My connection works but, when I click on my link to run my app I get the message that the LibraryList keyword is not supported.


25/11/14 18:22
Tammy, may it be that the code hasn't been generated since you changed to DB2? Could you try a Rebuild of your main or Rebuild All ? Regards, Armin On Tue, Nov 25, 2014 at 5:02 PM, Tammy Scott


25/11/14 18:23
Ok. thank you. I never thought of that.

Back to gxenglish-l