Link to home
Create AccountLog in
Avatar of jjoz
jjozFlag for Australia

asked on

Need help in SAP BPC and Infor Q&A Excel add-ins conflict

Hi,

I'm having problem in my Excel 2007 SP2 with the conflicting Excel Add ins (after the SAP BPC 7.5 add ins install the existing Infor Q&A keeps on infinite installing - MSI installer), does anyone know where and how to diagnose or troubleshoot this issue please ?
ASKER CERTIFIED SOLUTION
Avatar of nordtorp
nordtorp
Flag of Norway image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of jjoz

ASKER

ah ok, because before I install the SAP BPC client everything works fine until I install the SAP addins only the Infor Q & A addins broke down, the SAP BPC install ok
Please check the keys in this registry location:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins

Please post the name of your addins and the value of the LoadBehavior values.


Avatar of jjoz

ASKER

ok, here's the screenshot and the detailsthat you suggested to me, however in the regedit the Infor Q&A v10.0.4 is not listed in there ?

but is in the Excel Addins section
BPC.JPG
QnA.JPG
Avatar of jjoz

ASKER

and this is what I have got when I click on the addin link
ExcelAddins-Error.JPG
Does this happen even if you have closed Excel?

Have you tried to disable the Excel Add-in before you install? If not, does it fail even then?
Avatar of jjoz

ASKER

yes I tried to disable the "Vision" / the other name of Infor Q&A before while installing the SAP BPC the installation is OK, SAP is happy, but then when I enable the Add ins and then execute it, it always failed and installing infinitely in every button that i pressed in the addins :-|
As you saw, you did not have the add-in in registry. Try to remove (uninstall) the Vision add-in from the system. Restart the system. Remove any pointers to this add-in from %appdata%\<username> and %appdata%\All Users

Try to install the file again with the parameters mentioned earlier in this thread.

msiexec /i package.msi /L*v C:\msi.log

Open in new window


Did you get a warning or error in the event log or did you get an information value saying MSI Installer succeeded?

Can you post the msi.log when you have run this command?
Avatar of jjoz

ASKER

OK, The actual Infor Q&A Addins is eventually working but not fully running smooth since in every command that I clicked I got the MSI install Error 1720 pop up and then the Warning below is always logged after the Error.
Event Type:	Error
Event Source:	MsiInstaller
Event Category:	None
Event ID:	11720
Date:		5/04/2011
Time:		10:34:13 AM
User:		WS-BPCT01\Administrator
Computer:	WS-BPCT01
Description:
Product: Query & Analysis -- Error 1720.There is a problem with this Windows Installer package. A script required for this install to complete could not be run. Contact your support personnel or package vendor.  Custom action BackupSettingsFile script error -2146828287, Microsoft VBScript runtime error: Unknown runtime error Line 91, Column 3,  

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 7b 39 35 44 34 31 35 35   {95D4155
0008: 36 2d 42 30 31 45 2d 34   6-B01E-4
0010: 31 42 34 2d 38 39 44 41   1B4-89DA
0018: 2d 41 41 45 45 34 39 31   -AAEE491
0020: 33 39 33 35 33 7d         39353}  

Event Type:	Warning
Event Source:	MsiInstaller
Event Category:	None
Event ID:	1004
Date:		5/04/2011
Time:		10:39:15 AM
User:		WS-BPCT01\Administrator
Computer:	WS-BPCT01
Description:
Detection of product '{95D41556-B01E-41B4-89DA-AAEE49139353}', feature 'ThirdParty', component '{EB43DD72-D405-4707-AA75-5358D4726408}' failed.  The resource 'C:\WINDOWS\system32\XceedZip.dll' does not exist.

Event Type:	Warning
Event Source:	MsiInstaller
Event Category:	None
Event ID:	1001
Date:		5/04/2011
Time:		10:39:15 AM
User:		WS-BPCT01\Administrator
Computer:	WS-BPCT01
Description:
Detection of product '{95D41556-B01E-41B4-89DA-AAEE49139353}', feature 'ThirdParty' failed during request for component '{9AFC70A9-9FCB-40DF-B81F-F24E49E0275E}'

Open in new window

SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Avatar of jjoz

ASKER

found one file is missing after looking at the event viewer.