When a sandbox or development instance got refresh by a production instance, some information or data gets lost. The following have to be renewed or create again.
- Skyvva license key
- certificate
- Keystore
License key
After refreshing, the license key is not valid anymore. You will see this error message when trying to send data to Salesforce. Before refreshing your sandbox, you can save your old license key somewhere to use later.
We have to add a new license key. To do this go to the user used for the integration.
Here the SKYVVA license key. This is now invalid after a refresh.
To generate a new license key following information is needed:
- Organization Name e.g. SKYVVA
- Salesforce.com Organization ID e.g. 00D6F000002TBb2
Old license key: x+xEkW4TGfboVpynKj7MvF3fzZc=????MTY3NzY5MDAwMDAwMA==
Old/New license key:
Now you can apply the old/new license key.
Go to edit mode and enter the new key provided by mail:
Here is the mail you got after acquired a new key.
Dear Lyna,
Below find the requested License Key:
Account: SKYVVA
Contact Name: Reach Pech
Contact Email: vannphareachpech@gmail.com
Org Name: SKYVVA
Org ID: 00D6F000002TBb2
Product: SKYVVA Integration Suite – Unlimited Edition
Environment: Production
Status: Contract
Valid to: 11/09/2023
License Key: QG//+O/KJ4PAvFubkyDsEqNNQ8s=????MTY5NDQ1MTYwMDAwMA==
For activating the license key just do the following:
- Go to the “User Page Layout” and add the field “SKYVVA License Key”
- Go to the “User” in charge for the integration and insert the license key in the field “SKYVVA License Key”
In case you need, further help does not hesitate to contact the SKYVVA support team (support@skyvva.com).
SKYVVA
Simply Native Salesforce Integration
The Organization Id is different in both instances on sandbox and Production. The question was raised if the Org-Id became overwritten by the ord Id of the production. The answer is No. The org id between Sandbox and productive is different.
- Prod-Org Id: 00DU0000000K46I
- Sandbox Org-Id: 00DZ0000000pc6o
However, why has the org id been changed in the sandbox after a refresh? This is a normal case in SF while refreshing an instance.
Because of the Org-Id. has been reset and a new one has generated the license key is not valid again.
Certificate
For example, after refreshing a dev/sandbox instance from a productive instance, the certificate got lost and you have to create it again. However, you do not have to create them again. We are talking here about download each certificate and export Keystore.
Note: Please remember that, before you refresh your sandbox you have to save your certificate otherwise the Keystore will override. However, if you don’t have any Keystore then please skip the steps below.
- Download certificate
After you have created the certificate, you can download it and install into a reverse proxy or other components.
Open the list of certificate management screen and click on the appropriate certificate, which you want to download from Salesforce.
Open the certificate you have created and click on the button “Download Certificate”. You have to save it to a directory on your PC at your choice.
Here how the certificate looks like. Now you can use this certificate e.g. import it into the SAP Web dispatcher.
- Save Keystore
To save keystore you can follow some steps below:
Here you can check the certificate and key management in Salesforce.
Click on “Export to Keystore” button.
Input the password and click the Export button to save the keystore.
Adapt the outbound Adapter if needed
This step you need only if the name of the certificate has been changed when created it again after a refresh. If you keep the old name then you do not need to adapt the adapter. Not that this step is optional.
Currently, the adapter for the outbound interface looks like this:
Therefore, the name used here is “GRT_SAPDis”. Now we change the name to the new one e.g. to “CPQIntegrationUserCert”.
Note: we recommend creating a new self-signed certificate with the old name. In this case, you do not need to adopt the certificate in the adapter.
Take care to enter the correct name into the adapter. You have to take the name under the field “Unique Name” here in this example “CPQIntegrationUserCert”. Do not take the Label on the left side. In this example, we have given both fields the same name. Therefore, it is not a good example for showing about difference name.
Now go to the adapter and adopt the name of the certificate if you name it differently from the old one.
Click on “Edit” to change the value.
Now save it.
This is now the result after changing the certificate name of the adapter object.
User and Password in the adapter (outbound call)
After refresh, the user and password are encrypted again when inserting the new data. So it is double encrypted and the decryption is not working. Therefore, the user and password have to be adapted as well.
We can test the adapter and we can see this error now:
Now we change the user and password.
After changing user and password, we do not get the error with “unauthorized” anymore. Here is the test result:
So now, we can resend error message from the SKYVVA monitoring again to SAP. Here the error in the SKYVVA monitoring before we change the user and password:
When we select the entire message and reprocess it will do in batch via an Apex job. Here we can see the apex job for the reprocessing.
The number of “Total Batches” is 5 e.g. it was 5 messages to be reprocessed.
Now the reprocess is completed. Now the message is green in SKYVVA monitoring.
Test Connectivity
In Skyvva we can do a connection test from Salesforce to SAP.
We can do technical ping. Here is an example where the ping is not successful. The problem was not clear and after the restart, the sap web dispatcher the ping test is working. Here is the result.
Now we do a test connection with the test payload. The result of the test looks like this:
This is ok since the test payload is not correct we get this exception from the soap sender channel.
This error is ok at the SAP-PI adapter side. We see that the connection went through the firewall and that the soap sender channel received the data from Salesforce. Nevertheless, this data is not correct and this is ok like this. We just want to test the pure technical connectivity and if the firewall is, open for Salesforce.
Here the error message last time while the connectivity was not working.
Now we resend this message again after we restart the sap web dispatcher. The message was successfully reprocessed.
Adapt the integration Id in PI-Mapping and Module
In the mapping of the SF-Inbound interface, you have to adapt the integration Id in the interface determination in the directory.
Like shown in this screen in the mapping you will need the integration id but you pass the integration Id from the directory at the configuration time at the interface determination.
Here in the interface determination, you have to enter the new integration Id.
The integration id is used in the SKYVVA module as well and here you have to adapt it as well.
The parameter session pooling. Integration ID has to be adapted to the new integration Id value.