Replies posted by LowBjorn
@Marcel Hunting After reading you comment I did some experimenting and currently this happens in the model building phase (so not during the solve, my bad).Can AIMMS use more resources in this case? My overall aim is to find out if there are throttles on performance that I could possibly undo.
I have found a recursive solution allong the following lines:Define s_Children(i_node) to contain all direct descendants Define s_ChildrenAux(i_node) to contain all direct descendants of each node in s_Children(i_node), minus the nodes already contained in s_Children(i_node) Add s_ChildrenAux(i_node) to the set s_Children(i_node) and clear the auxiliary set. Repeat until no elements exist in the auxiliary set after generation. It works, and is quick enough. If there’s an answer without a loop I would still be very interested.
@mohansx I just realised that the formulation of my question was a little off compared to my aimms structure. In fact, the edges are defined through a binary parameter that indicates if an edge exists from node1 to node2. e.g. p01_EdgeExists(node1, node2) := 1; indicates that there is an edge.I updated my post.
Hi Chris, thanks for you reply. Unfortunately I still get the same error (included at the bottom of this post). I started with creating a new sample table (in MSSQL): CREATE TABLE [tmp].[aimmsTest]( [ID] [int] IDENTITY(1,1) NOT NULL, [value] [int] NULL, CONSTRAINT [PK_aimmsTest] PRIMARY KEY CLUSTERED ( [ID] ASC) INSERT INTO [tmp].[aimmsTest]([value]) VALUES (5);INSERT INTO [tmp].[aimmsTest]([value]) VALUES (6);INSERT INTO [tmp].[aimmsTest]([value]) VALUES (7);INSERT INTO [tmp].[aimmsTest]([value]) VALUES (8);INSERT INTO [tmp].[aimmsTest]([value]) VALUES (9); And in AIMMS I made the exact same procedures, dbtable, parameter, set and index. Of course also the mapping in the dbtable is done in the same manner. Reading data into the set and parameter worked as expected, however, when trying to run write to table db in replace mode ; I (still) get the following error: (in a spoiler because it is long) Error writing to database table "db_GetData": ODBC : 23000 [Microsoft][SQL S
Already have an account? Login
Please use your business or academic e-mail address to register
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.