Creating SQL datastore in FIM

Hi,

We are trying to create a SQL datastore in FIM, but it is giving error " Invalid Datastore".

We are able to connect to the SQL database through SQL developer by using the same credentials, but when we try to connect through FIM, it is giving error.

Please let us know if we need to do any settings in FIM server to get connected to sql.

Many thanks in advance

Regards

Srikanth

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hello,

Could you confirm the version of FIM used ?

Could you attach a screen shot of the error message?

Regards,

Soumaya

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Soumaya,

We are using FIM 10.0

The below is the error screen shot.

Thanks

Srikanth

Hello,

Here it seems that you escalated the same issue before :

http://scn.sap.com/message/16379831#16379831

Have tried all the solution mentioned before

Regards,

Soumaya

Hello,

Can you try to connect with the same credentials to the SQL server?

Best regards,

Inès

Hello Ines,

Yes, I can connect to SQL server using the same credentials.

Thanks

Srikanth

Hello Srikanth

Can you provide the error from the FIM log, this will show more details.

Thanks

Marc

Hi Marc,

The below is error screen shot in FIM.

Thanks

Srikanth

Hi Srikanth

No, I really mean the FIM log. The screenshot error is meaningless - if you type in the wrong password, you would also get the same error message

Check the C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\webapps\fim\WEB-INF\tracelog.ini

Set the logging to debug, and specify the path

Then, you should get a file 'TraceLog_<date_time>_trace.glf"

In here, you will see the real underlying error

For example:

Error on screen

Error in log

|690793A17FF2416D9F24135048B2F2F29|2016 05 02 06:22:04.130|-0700|Error| |>>| | |TraceLog| 1500| 48|http-8080-2 | |24|0|0|0|FIMServer.IConnectionServices:validate|AIO2:1500:48.6332:1|-|-|FIMServer.IConnectionServices:validate|AIO2:1500:48.6332:1||||||||||com.sap.fpm.fim.administration.IConnectionServices||Connection 'TEST' is invalid.

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host AI02, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".

Marc

Hi Marc,

Could you please let me know how to set the logging to debug and specify the path.

I have tried by specifying the path but no log has been created.

active = true;

importance = '>='; // logging levels in decreasing verbosity is <<, <=, ==, >=, >>

log_dir ="C:\Users\administrator.XXX-AUTH-DEV\Desktop"

Regards

Srikanth

Hello Srikanth,

I am using:

active = true;

importance = '>=';

log_dir = "C:\";

You can also check the standard Tomcat logs:

C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\logs\stdout.log

C:\Program Files (x86)\SAP BusinessObjects\Tomcat6\logs\stderr.log

The error is probably captured in these logs as well

Marc

Hi Marc,

Thanks for the information.

I have attached the FIM error log.

Regards

Srikanth

Hi Srikanth,

The error is pretty clear, you have connectivity issues between your FIM server and DB server:

The TCP/IP connection to the host 11.111.11.22, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port."

This has nothing to do with FIM, you can search for this error, e.g.

http://stackoverflow.com/questions/18841744/jdbc-connection-failed-error-tcp-ip-connection-to-host-f...

http://www-01.ibm.com/support/docview.wss?uid=swg21623142

http://stackoverflow.com/questions/13681315/sqlserverexception-tcp-ip-connection-to-the-host-has-fai...

Marc

Hi srikanth,

try to ping and telnet your db server:

from FIM server cmd: ping 11.111.11.22

from FIM server cmd: telnet 11.111.11.22 1433

Also try to disable antivirus/firewall (Windows and third-party)

Ask a Question