Skip to Content
0
Former Member
Aug 15, 2016 at 10:40 AM

AL_LANG is empty!!!!

178 Views

Hello everyone,

I lost my project and I'm really looking for your help.

I have DS 4.2, SQL server 2008, windows server 2008 and windows 7 (I used to have this project under Central, Production and my local repository)

Now I can see only project folder and all jobs, workflow, dataflow are missing!!!

I tied to check AL_LANG table I found it empty!!! when trying to create a new job and try to save it, I got the below error in repository:

Internal application error: Error message:
Cannot save <Language Object> <New_Job> into the repository. Additional database information: <SQL submitted to ODBC data source <000.000.0.000>
resulted in error <[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'DB',
table 'BODS_TEST.dbo.AL_LANG'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.>.
The SQL submitted is <INSERT INTO "AL_LANG" ("OBJECT_KEY", "OBJECT_TYPE", "NAME", "VERSION", "TYPE", "GUID", "OWNER", "DATASTORE", "NORMNAME", "STATE", "CHECKOUT_DT", "CHECKOUT_REPO", "CHECKIN_DT", "CHECKIN_REPO", "COMMENTS", "LANGSIZE", "SEC_USER", "SEC_USER_COUT")
VALUES (1, 0, N'New_Job', 1, 0, N'c0b74588-fd7d-4bb9-b962-5233f9b0b8ce', NULL, NULL, N'NEW_JOB', 0, NULL, NULL, NULL, NULL, NULL, 1635, NULL, NULL)
>.>.

Any ideas can help me to recover this project, as I can see all details about jobs under dbo.AL_PROJECTS, AL_LANGXMLTEXT, AL_PARENT_CHILD?

But is not coming under Data service designer anymore becuase of AL_LANG become empty 😠