Customers may see the following error when refreshing metadata for the Adapter or the error may appear in trace logs.
---->
INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations
at SFDCAdapter.clsSForce.DescribeTable(String tableName, DescribeSObjectResult& result)
at SFDCAdapter.Database.DoFieldFactory_SObject(Object db, Object tbldef)
<----

The error indicates that the password of the Salesforce user has been expired and must be reset. As per the Salesforce password policy, by default, the password expires every 90 days.

In TIBCO Scribe Insight, users can log in and test salesforce connections successfully using expired password credentials but it is restricted to make few API calls and the only allowed operation is setPassword() method call.

 

Resolving error 'INVALID_OPERATION_WITH_EXPIRED_PASSWORD' for Salesforce connection when using TIBCO Scribe Insight Adapter for Salesforce.

To resolve this error, the suggestion would be to Reset your Salesforce user password or may reach out to your Salesforce Admin to reset the password and use a new password.

Note: Whenever a Salesforce user's password is reset or changed, automatically a new security token gets generated. This newly generated security token is required next to the new password while configuring the connection in Scribe Insight.

Also, If a DTS using a Salesforce connection, and if the user's password or security token gets changed or expires, the connection name appears to be in "red" when DTS opens in the scribe workbench. Please see the below-attached screenshot,


To verify the connection is working, try refreshing metadata for connection. Please see below knowledge article to refresh metadata for salesforce connection.

https://support.tibco.com/s/article/Refresh-Metadata-with-the-Salesforce-Adapter

https://help.salesforce.com/s/articleView?id=sf.admin_password.htm&type=5