-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Problem in User_Addr
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Problem in User_Addr
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Apr 28 12:46 PM
- SAP Managed Tags
- ABAP Development
Hi All,
The view USer_Addr when executed to see the entries is giving a Dump in one of the Qulaity servers .The dump is time_out.But the same view is working fine in Development server.The possible entries in Quality server would be not more than 5000 , so can it still pose a problem in this much entries or there could be some other problem.
plz help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Apr 28 12:58 PM
- SAP Managed Tags
- ABAP Development
Hi Umang,
At out place (with 12.000 users and the ADRC table with millions of addresses) it works fine, so this puzzles me a bit.
However an explanation for this could be that the field PERSNUMBER in table USR21 is not filled. This would cause the join statement to sequentially search through the joined ADRP and ADCP tables.
If this is the case, then you should build your own view (or not use this one and program the dataselection yourselve).
Regards,
Rob.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Apr 28 1:54 PM
- SAP Managed Tags
- ABAP Development
Hi Rob,
Thaks for the reply but field PERSNUMBER in table USR21 is correctly populated, and also the tables ADRP and ADCP.
But still the view USER_addr is not functionaing properly.
I am knocked out because of this.
any more suggestions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Apr 28 2:07 PM
- SAP Managed Tags
- ABAP Development
Hi Umang,
I think the problem is not in USER_ADDR Database View. In your quality server, the Tables USR21,ADRC,ADRP and ADCP may be having More amount of Data. Thats why the Time Out Exception has come. Please check your Database Tables.
Regards,
Jeyakumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Apr 28 3:04 PM
- SAP Managed Tags
- ABAP Development
Hi Umang,
I think in this case that Jeyakumar is right.
Please check the following:
Is table ADCP active AND created on the database?
Is table ADRC active AND created on the database?
Is table ADRP active AND created on the database?
Please check also the indexes via transaction SE14 if the really do exist on the database. Specific you need to check the tables ADCP and ADRP.
To find out the problem, you could first use transaction SE11 (fill in the viewname and display it). Then press the contents button (or press CtrlShiftF10) and simply execute an empty screen with maximum number of hits slowly rising.
Regards,
Rob.
Bluesky