Error to install the B1A

[former_member203128]

Hi all

I am trying to install the SAP Business One, analytics powered by SAP HANA 1.0.5.341 but in the installer when I select the Connection Settings give me the next error message:

"A version of SAP Business One, analitycs powered by SAP HANA is already associated with the selected SAP Business One server. Select a different server or unistall the existing version and try again."

Initially the server has a older version of B1A, I uninstalled that version totallyof Linux Server, but I think that is something in the SAP server (where company databases resides) that I missing to uninstall but I dont find anything about this topic.

Any one can help me?

Regards

Alvaro González

[Former Member · Accepted solution]

Hi Alvaro, Did you get any solution for this problem? i am in the middle of the same situation.

Please share any information if you can.

Thanks in advance.

Carlos.

[duncanspeidel · Accepted solution]

This happens because the SBOCOMMON DB on MS-SQL has an entry telling it that the Business One is connected to a B1A system.

1.

//Done on SBOCommon DB

SELECT * FROM dbo.SLSPP

WHERE ParamID IN

(SELECT T0.ParamID FROM SLSPP T0

LEFT OUTER JOIN SLSP T1 ON T0.CompID = T1.CompID

WHERE T1.CompType = 'IMCEsrv')

SELECT * FROM dbo.SLSP where CompType = 'IMCEsrv'

//This returns the connections to B1A HANA from B1.

2.

DELETE FROM SLSPP

WHERE ParamID IN

(SELECT T0.ParamID FROM SLSPP T0

LEFT OUTER JOIN SLSP T1 ON T0.CompID = T1.CompID WHERE T1.CompType = 'IMCEsrv')

DELETE FROM SLSP where CompType = 'IMCEsrv'

//This undoes the connection.

[former_member203128 · Accepted solution]

Hi Duncan,

This is possible? I can delete a row from SBOCommon DB? I will not have any problems with this situation?

Regards

Alvaro

[duncanspeidel · Accepted solution]

Hi Alvaro,

Generally, you cannot but in this situation it is ok.  Please export the row please you execute the delete.  This gives you a fallback position if something unexpected happens.

Best regards,

Duncan

[Former Member]

Hello!

I already have this problem, but when I did your solutions I had another problema:

The system give me this message:

Database User COMMON has already  existed in SAP HANA instance.

Do you knon what can i do?

Thank you!

[duncanspeidel]

Hi Rosa,

You can try and delete the COMMON schema using the HANA studio.  Or you can uninstall B1A before reinstalling.

Best regards,

Duncan

[former_member240360]

This message was moderated.

[johan_nordlf]

Hi Alvaro,

Did you get any solution to this problem? I get exactly the same error message and don't really know what to do...

Regards

Johan