error microsoft .net framework

[Former Member]

Hi,

I work whit BPC MS 7.0 and SQL Server 2008.

when i adding a new "data flow task" into a package and on excel i try to modify the modifyscript returns this error:

• Testo dell'eccezione **************

System.ApplicationException: Errore dell'applicazione.

in OSoft.Consumers.DataMgr.PackageModify50.PackageDetail.GetPackageDetailfromServer(String strPackageName, String strPackageFilePath, String strTeamID)

in OSoft.Consumers.DataMgr.PackageModify50.frmMain.PackageListClickEvent(String strPackageID, String strPackageFileName, String strTeamID)

in OSoft.Consumers.DataMgr.PackageModify50.frmMain.SetStartUp()

in OSoft.Consumers.DataMgr.PackageModify50.frmMain.frmMain_Load(Object sender, EventArgs e)

in System.Windows.Forms.Form.OnLoad(EventArgs e)

in System.Windows.Forms.Form.OnCreateControl()

in System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)

in System.Windows.Forms.Control.CreateControl()

in System.Windows.Forms.Control.WmShowWindow(Message& m)

in System.Windows.Forms.Control.WndProc(Message& m)

in System.Windows.Forms.ScrollableControl.WndProc(Message& m)

in System.Windows.Forms.ContainerControl.WndProc(Message& m)

in System.Windows.Forms.Form.WmShowWindow(Message& m)

in System.Windows.Forms.Form.WndProc(Message& m)

in System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)

in System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)

in System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

thanks/regards,

Dario T.

[Former Member]

Hi Dariotri,

I'd try to modify/check a few things using MS Visual Studio:

1. I'd set package ProtectionLevel to "DontSaveSensitive"

2. Make sure all connections in your package (SQL, OLEDB, ADO, File etc) are valid even if they are being modified @ runtime.

3. Are there any custom SQL Server tasks (non-SAP and non-SQLnative) in your package?

4. Try to take a copy of working DM package (any other than the one you have an issue with) and modify it the same way you have the failing one.

Regards,

Akim

[Former Member]

Hi Akim

I've tried all 4 your suggestions and the problem is the same

Regards,

Dario T.

[Former Member]

I've noticed non-English OS: "Errore dell'applicazione."

Could that be a reason for BPC to crash?

Regards,

Akim

[Former Member]

Hi Akim,

Please change the language to English and try again.

Hope this helps.

[Former Member]

I guess that advise is addressed to Dariotri.

Regards,

Akim

[Former Member]

hi,

I have already done this, but it has the same error

Regards,

Dario T.

[sorin_radulescu]

It seems the installation was not completed.

I'm not sure if the problem it is into cliend side or server side but I think one of these two installation was not succesfuly completed.

I suppose is into server side but more investigation has to be done.

Are you able to run any DM stanard package?

Of course you have to try from different BPC clients.

If not then I will say the installation of some COM+ components or DLL into server side was not done correct.

Please check if antivirus is disable into client side and also into server side when you perform the new verifications.

Regards

Sorin Radulescu

[Former Member]

Are you able to run any DM stanard package?

yes

Of course you have to try from different BPC clients.

yes i've already did it, and the problem is present on all clients.

If not then I will say the installation of some COM+ components or DLL into server side was not done correct.

how can i check?i have not got admin rights on the server

What's weird is the fact that the system has been working for months, and suddenly, a few weeks ago we got this problem...

thanks

Dario T.

[Former Member]

Hi Dario,

There might be a possibility that some windoes update has been installed and that might be conflicting with the dll files.

[Former Member]

you think on the server or on the client?

Regards

Dario T.

[Former Member]

Hi Dario,

On the server.

[Former Member]

hi nilanjan,

the last update on the server are:

Security Update for Windows Server 2003 x64 Edition (KB2079403)

Security Update for Windows Server 2003 x64 Edition (KB2160329)

Security Update for .NET Framework 2.0 SP2 and 3.5 SP1 on Windows Server 2003 and Windows XP for x64-based Systems (KB983583)

Security Update for Windows Server 2003 x64 Edition (KB980436)

Security Update for Windows Server 2003 x64 Edition (KB982214)

Security Update for Windows Server 2003 x64 Edition (KB2115168)

Cumulative Security Update for Internet Explorer 8 for Windows Server 2003 x64 Edition (KB2183461)

Windows Malicious Software Removal Tool x64 - August 2010 (KB890830)

thanks

Dario T.

[Former Member]

Hi Dario,

It will be difficult for me to pinpoint at a particular update. But I have seen cases where windows updates had conflicts with BPC and uninstalling those updates solved the problem.

[sorin_radulescu]

Are we speaking about a BPC task or about a SQL 2008 task?

Also can you try to do modify package for a standard package?

Is it working or you are receiving the same error?

Regards

Sorin Radulescu

[Former Member]

Are we speaking about a BPC task or about a SQL 2008 task?

both

Also can you try to do modify package for a standard package?

I try to modify the standard package and the error is the same but i can modify the package whit notepad and the error is the same

Is it working or you are receiving the same error?

the error is the same.

Have you registered all the necessary DLLs for BPC related SQL tasks in BIDS?

yes

the package comes executed correctly does not only succeed to modify it by excel

thanks to both

Dario T.

[Former Member]

Hi Dario,

Can you please elaborate on the steps you followed.

Have you registered all the necessary DLLs for BPC related SQL tasks in BIDS?

[Former Member]

Hi experts,

Any idea?