Skip to Content
0
Jun 20, 2018 at 07:24 PM

Outlook Integration setup fails "cannot create Executive Customer.. "

57 Views

I am running two companies within SAP 9.1 and am configuring new PCs for the office. I installed SAP under the Administrator ID with no issues.

I logged into the company 1, it started the Outlook Integration add-on, asked about templates, I said to create and overwrite and it did with no issues.

I logged into company 2, it started the Outlook integration add-on, asked about templates I said to create and overwrite, it started copying files then when it got to "Executive Customer (by Business Partner) it popped up and stated "Failed to create template..."
I hit ok and it waits for me chose something else.

I have verified the xls files are in place, permissions etc, again same MACHINE just a different company. I looked in the logs and found "

2018-06-20 13:29:35.424 0BOD0CBO_Util::GetStringFromDBSQL: "SELECT U_NAME FROM OUSR WHERE USER_CODE = N'User'" 2018-06-20 13:29:35.470 0BOD2CBO_Util::GetStringFromDBLeaving function
2018-06-20 13:29:35.486 0BOD2CBO_Util::GetUserNameLeaving function
2018-06-20 13:29:35.502 0BOD2CBO_SnapshotTemplate::SetNewIDEntering function 2018-06-20 13:29:35.533 0BOD2CBFUtil::GetNextCodeValueEntering function
2018-06-20 13:29:35.533 0BOD0CBFUtil::GetNextCodeValueSQL: "SELECT MAX(Code) FROM [@BOOSTP]"
2018-06-20 13:29:35.564 0BOD2CBFUtil::GetNextCodeValueLeaving function
2018-06-20 13:29:35.580 0BOD2CBO_SnapshotTemplate::SetNewIDLeaving function [S_OK]
2018-06-20 13:29:35.611 0BOD0CBO_SnapshotTemplate::SaveSQL: "INSERT INTO [@BOOSTP] (Code, Name, U_TplName, U_Language, U_CPData, U_CatID, U_LFileXls, U_LFileTxt, U_Version, U_Default, U_CrtUser, U_CrtTime, U_Host) VALUES ('0000000A', '0000000A', N'Executive Customer (by Business Partner)', 3, 'N', 18, N'Default\EN\EXE_C_BP.xls', N'', N'9.10.220.12.00', N'Y', N'User', getdate(), N'MachineName')"
2018-06-20 13:29:35.611 0BOERCBO_SnapshotTemplate::SaveError: DI API SQL failure

There are no entries in the Define template section.
If I pull up the BOOST in user tables it shows the template entries.

What is going on? We don't even use them, if I could get the popup to go away I wouldn't care.

Anyone have any ideas?