170
Hi everyone,
while i am trying to run a table, but table not showing records and getting in infinite loop.
even when i am trying to retrieve data from table through SQL query, query not getting finished, it is also going to infinite loop.
*This post is locked for comments
Hi Sunil,
As Vishal said you might be checking in some other company.
I would suggest you to check to 5000 records in query. This will help you to analyse whether you are executing query in correct company or not.
Regards,
Neeraj Singh
I think, you are not checking the right NAV table in SQL. There must be some company holding lot of records in the tables and hence it is taking longer time.
Check this query.
select Count(*) from [tablename] and see the No. of Records in this particular table. There might be multiple companies in the NAV and might be misleading you in terms of number of records.
4k records is nothing for sql. Theoretically, there might be a problem with one certain record. You can troubleshoot to find it. Select top 100 rows. If it does not go well, then select top 50. If it works fine, then potential problematic record is between 50 and 100. Select top 75 then, etc. divide you range in two unless you shorten your range to few records. I guess you have got the idea.
If you manage to identify a problematic record, analyze it. Look at what is written in the fields, perhaps you will find some wierd data...
I too have the same Question what Alex asked.
Apply this Query
Select TOP 1 * from [TABLENAME] WITH (NOLOCK)
How many records does this table have? What are exactly the customized fields and what are the logic behind them?
Yes, if i am trying to retrieve the filtered record from this table by SQL query, it's working.
but when trying to retrieve all record it's getting stuck.
Table is "Purchase Line", and there are some customized fields in this table.
Hello Sunil,
Use bellow command in SQL query and Replace the DB Name, Company Name, Table Name as per your Table.
/****** Script for Select Top 1st Row command from SSMS ******/
SELECT TOP 1 * FROM [Demo Database NAV (7-0)].[dbo].[CRONUS Canada, Inc_$Customer]
After execution of this command what you get, let me know.
For better response mention clearly Like: Table ID, [Customize or Standard or Add-ons].
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (