B1if | Message log empty

[Former Member]

Hi All,

I have been working with B1if for a while. Two days ago after reinstall the SQL server and attaching all the databases back(including B1if), the Message log doesn't show any transaction log, not even for default scenarios. The MSGLOG table is not empty, but when I filter by date, the message logs results in B1if remains empty. The scenarios are working fine, I just can't see any log in the Message Log view and the new transactions are not being inserted in the MSGLOG table neither. Some help here will be appreciated.

Best regards,

Gabriela

[former_member541458 · Accepted solution]

Please check SLD->B1iServer credentials if they are okay and click [Test Connection] to verify if B1if processes (e.g. Message Log) can connect to the database (B1iP=Technology retrieves the credentials not from here but from xcellerator.cfg). If this is working as well, I would start debugging. Debugging must be switched on (in xcellerator.cfg and for the step). Pick up any transaction from Process Control (from the group Scenario Processes - Processing) and click [Debug] button. Choose the last transaction on top and click [Debug]. Scroll to the right, at the end you see a huge branch with many path. In the 4.path there is an include. Click on it. You see now the debugging of the Message Log. Click on the red arrow of the last XForm atom in this flow. You can see the result of the insert to the Message Log table in /bfa:unbranch/bfa:unbranch/bfa:call/bfa:outbound. Here you should see some error message of the database that can give you some hint to the root cause.

[Former Member · Accepted solution]

Hi Heinz,

Thank you for answer me. I tried to test the connection for the B1iServer in SLD and it shows a login error

Can you tell me how to reconfigure this??

Thanks in advance,

Gabriela

[former_member541458 · Accepted solution]

at least we found the root cause 🙂 ... One of the 4 credentials is wrong. The driver is okay. In url, please check if the IP-address and name of db is okay. If username is correct, then I guess the problem is the password. I think you need to type in again the correct password and save it. The password is stored encrypted. The encryption algorithm also involves the MAC address of the particular computer. So after changing environment the encrypted password is not valid anymore.

[Former Member · Accepted solution]

Yes, definitely this is the cause 😉 .I checked the ipaddress and db name and these are correct but I am not sure how to change the password because of the encryption.

[former_member541458 · Accepted solution]

just click the edit icon and type in the correct password. Then click the save icon. The save operation will automatically encrypt it.