"Failure when creating frePPLe plan: Exit code of the batch run is 1"

[Félix Oyarce]

Please; I need your help. i am starting with frepple. when i run my plan, the program give me this error:"Failure when creating frePPLe plan: Exit code of the batch run is 1"

Here is the log file: 

Start logging frePPLe 0.9.2 (Aug 29 2012) at 2013-04-25T21:20:29
Plan type:  1
Constraints:  15
frePPLe on win32 using sqlite3 database 'C:\Program Files\frePPLe 0.9.2\bin\custom\frepple.sqlite'

Start loading data from the database at 21:20:29

Size information of frePPLe 0.9.2 (Aug 29 2012)

Locale: Spanish_Argentina.1252

Loaded modules:
   forecast

Clusters: 0 (hanging: 0)

Memory usage:
Model        	Number	Memory
-----        	------	------
Plan         	1	96
Location     	0	0
Customer     	0	0
Buffer       	0	0
Setup matrix 	0	0
Resource     	0	0
Operation    	1	279
Flow         	0	0
Load         	0	0
Calendar     	0	0
Item         	0	0
Demand       	0	0
OperationPlan	0	0
FlowPlan     	0	0
LoadPlan     	0	0
Problem      	0	0
Total        		375

Importing parameters...
Importing calendars...
Loaded 9 calendars in 0.02 seconds
Importing calendar buckets...
Loaded 433 calendar buckets in 0.28 seconds
Importing locations...
Loaded 3 locations in 0.00 seconds
Importing customers...
Loaded 1 customers in 0.00 seconds
Importing operations...
Loaded 32 operations in 0.01 seconds
Importing suboperations...
Loaded 0 suboperations in 0.02 seconds
Importing items...
Loaded 41 items in 0.01 seconds
Importing buffers...
Loaded 41 buffers in 0.85 seconds
Importing setup matrix rules...
Loaded 0 setup matrix rules in 0.00 seconds
Importing resources...
Loaded 7 resources in 0.01 seconds
Importing flows...
Loaded 73 flows in 0.01 seconds
Importing loads...
Loaded 32 loads in 0.01 seconds
Importing operationplans...
Loaded 0 operationplans in 0.00 seconds
Importing forecast...
Loaded 0 forecasts in 0.00 seconds
Importing forecast demand...
Loaded 0 forecast demands in 0.00 seconds
Importing demands...
Loaded 1 demands in 0.00 seconds
Done

Size information of frePPLe 0.9.2 (Aug 29 2012)

Locale: Spanish_Argentina.1252

Loaded modules:
   forecast

Clusters: 4 (hanging: 1)

Memory usage:
Model        	Number	Memory
-----        	------	------
Plan         	1	96
Location     	3	519
Customer     	1	164
Buffer       	41	12259
Setup matrix 	0	0
Resource     	7	1951
Operation    	74	23808
Flow         	114	11856
Load         	32	4352
Calendar     	9	56173
Item         	41	8055
Demand       	1	271
OperationPlan	9	936
FlowPlan     	9	648
LoadPlan     	0	0
Problem      	66698	3201476
Total        		3322564


Start forecast netting at 21:20:41

Start plan generation at 21:20:41

Size information of frePPLe 0.9.2 (Aug 29 2012)

Locale: Spanish_Argentina.1252

Loaded modules:
   forecast

Clusters: 4 (hanging: 1)

Memory usage:
Model        	Number	Memory
-----        	------	------
Plan         	1	96
Location     	3	519
Customer     	1	164
Buffer       	41	12259
Setup matrix 	0	0
Resource     	7	1951
Operation    	81	26133
Flow         	121	12584
Load         	32	4352
Calendar     	9	56173
Item         	41	8055
Demand       	1	279
OperationPlan	139	14456
FlowPlan     	290	20880
LoadPlan     	260	20800
Problem      	47015	2256720
Total        		2435421


Start exporting plan to the database at 21:20:49
Emptying database plan tables...
Emptied plan tables in 0.28 seconds
Exporting problems...
Traceback (most recent call last):
  File "<string>", line 1, in <module>
  File "C:\\Program Files\\frePPLe 0.9.2\\bin\\custom\\freppledb\\execute\\commands.py", line 91, in <module>
    export_plan_to_database()
  File "django\db\transaction.pyo", line 209, in inner
  File "django\db\transaction.pyo", line 203, in __exit__
  File "django\db\transaction.pyo", line 288, in exiting
  File "django\db\transaction.pyo", line 52, in leave_transaction_management
  File "django\db\backends\__init__.pyo", line 119, in leave_transaction_management
django.db.transaction.TransactionManagementError: Transaction managed block ended with pending COMMIT/ROLLBACK
Error: Error executing Python command

Thanks

[Bruce Holt]

Felix, if you can send me the frepple.sqlite database (located in folder frepple/bin/custom/), I may be able to help. I had this problem before.

--
You received this message because you are subscribed to the Google Groups "frePPLe users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to frepple-user...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Félix Oyarce]

bruce, here is the file.

thenks

2013/4/25 Bruce Holt <bruce...@comcast.net>

[Bruce Holt]

Félix, there is a problem with the min calendar field in the buffer table. I blanked this field and all is now working. I added a demand record to test that everything is working. Attached is the resulting FREPPLE database after I made the changes and the test run.

[Bruce Holt]

Félix, I also changed the Buffer Type from “procure” to “infinite”. The frepple.sqlite database that I returned to you still buffer still has the buffer type as “infinite”. However, when I changed the particular items back to “procure”, a plan was still created.

 

From: Bruce Holt [mailto:bruce...@comcast.net]
Sent: Friday, April 26, 2013 7:34 PM
To: 'freppl...@googlegroups.com'
Subject: RE: "Failure when creating frePPLe plan: Exit code of the batch run is 1"

 

Félix, there is a problem with the min calendar field in the buffer table. I blanked this field and all is now working. I added a demand record to test that everything is working. Attached is the resulting FREPPLE database after I made the changes and the test run.

 

 

 

From: freppl...@googlegroups.com [mailto:freppl...@googlegroups.com] On Behalf Of Félix Oyarce

Sent: Friday, April 26, 2013 2:16 PM
To: freppl...@googlegroups.com

[Félix Oyarce]

Bruce: really thanks. I will test it tomorrow in the pc i have frepple, and i tell you.

Again thanks

2013/4/27 Bruce Holt <bruce...@comcast.net>

[Félix Oyarce]

Bruce; I runned the model for a demand of the item TF24030P300C LAVADO (the end item) and the problem continues. Can you help me?

Thanks

2013/4/29 Félix Oyarce <fjoy...@gmail.com>

[Bruce Holt]

Félix, I was able to fix the issues that were causing a problem. .I had to change the following. Where you used “1/2”, I changed it to “1-2”, Changed all of you special letters (non-english), replacing your “Ñ” with an English “N” and replacing your ” ª” with an English “a”.  After performing these changes, a successful plan was created for TF24030P300C LAVADO.

 

Let me know if this works for you.

[Félix Oyarce]

Bruce: it works, and the plan was created. There is a new problem: the inventory, resource, demand, forecast and operation reports screens are empty, and the plans of the all reports don´t charge because "Error in loading Data"

I send you images of screens:

Again; really thanks.

2013/4/30 Bruce Holt <bruce...@comcast.net>

[Bruce Holt]

All reports are  working on my installation. Be sure that you go to the user menu item and a bucket item is chosen. As you can see in the screen shot, the Buckets are selected and reports will be in Monthly buckets.