I created one search service application and started crawling file share and expecting to be complete in few minutes as there were not much items inside the shared folder.
But it was taking lot of time without even crawling single item. I tried multiple times, also I deleted the search service application and created new one. nothing helped. Finally I went to log file to track if there is any error and found it.
“ExecuteNonQuery fails with Error 0x80070057 Description ‘The value’s length for key ‘application name’ exceeds it’s limit of ‘128’ ”
When we create a search service application, we provide the name of the application and it creates the other DataBase (index DB, Analytics DB etc) by appending with some GUID as shown below image
If the database name goes beyond 128 characters, it throws the above error. So make sure the name of search application service is not bigger.
Thanks,
Prasanta