I am testing O4W. I set up IIS and OECGI3. It wasn't easy but I did all. I tried to create menu and there was a fatal error. After that whenever I try I've got

"Fatal Error: Unable to access O4WTEMP (O4WTemp) table"

How can I solve this problem. Please help.

Log into OpenInsight as the SYSPROG application. Open the Database Manager tool and verify the "O4WFILES" directory is attached and the O4WTEMP folder is listed as one of the attached tables in the directory.

You may need to restart the OEngineServer service after saving changes in the database manager.

Thanks Jared.

I verified O4WFILES and everyfiles is OK. O4WTEMP table is there. Even I copied O4WTEMP revfile from my copied system. But I still have same error. What is the next step to check?

In the registry for OECGI3 you had to specify an application name. Locate that application name and log into OpenInsight as that application. Next, open the Database Manager, is the O4WTEMP table attached?

Hi Jared,

Yes our application name is IES.

All files of O4WFILES were attached. Anyway

I just copied whole system again and I created menu and 1 form.

But now I have other problem. I saved 1 record by key. But I cannot read with error. I can see the record which I saved from my table.

Error message is

SYS1000: error loading program

"PTE_TRAINEE_GET_INTAKES"

My table name is PTE_TRAINEE.

Any idea?

Does the stored procedure PTE_TRAINEE_GET_INTAKES exist in the application and does it compile correctly? Remember, if you recompile a stored procedure the OEngineServer service must be restarted so the new compiled routine is active.

Are you familiar with the method of debugging web programs using the OpenInsight debugger?

Hi Jared,

I didn't make any stored procedure. I just crated form, and executed. First thing I could see from form is search by key field. I entered key, searched record and this error happened. I have no idea about PTE_TRAINEE_GET_INTAKES.

View this thread on the forum...