Incorta
Community
Learn
Docs
Support
How to enable Javascript
Login
Sign Up
Login
Search
Home
Latest Posts
0
PostgreSQL ODBC and/or JDBC versions
Are there a recommended versions of PostgreSQL ODBC and or JDBC drivers that have been tested with Incorta?
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
6 mths ago
15
Questions & Answers
Re: Is there a way to manually compact a table?
Tried a few more things and I ended up having to do a full load on just that one table. I'm now able to preview the data and the mv is working as expected.
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
9 mths ago
Questions & Answers
Reported - view
Re: Is there a way to manually compact a table?
Thanks for the information. We've had Always Compact turned on for as long as I know. The schema was new (imported from our Dev environment) so after it was imported I ran a full load.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
9 mths ago
Questions & Answers
Reported - view
0
Is there a way to manually compact a table?
I have a large table (85m rows) that I'm using as a source for a MV (python) and I was having an issue getting any rows returned. I know the mv works because it's working in another environment.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
9 mths ago
3
replies
34
Questions & Answers
Answered
Answered
Re: Format of Logging Setting - Server Configurations
@Seth Luersen That is exactly what I was looking for, thank you.
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
9 mths ago
1
Questions & Answers
Reported - view
Re: Format of Logging Setting - Server Configurations
Hi Ahmed, Thank you for the information. I checked what was currently set on our environments and both of them had the file logging.properties but both of them were just empty files.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
10 mths ago
Questions & Answers
Reported - view
0
Format of Logging Setting - Server Configurations
I would like to reduce the level of logging on our production system for the analytics and loading services. Actually for everything, services, spark, etc.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
10 mths ago
4
replies
64
Questions & Answers
Answered
Answered
Re: IO Error: Cannot run program "chmod": error=24, Too many open files
Thank you for the fast response. That link should help. I had increased the limit but I didn't comment out the soft in /etc/security/limits.d/20-nproc.conf.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
10 mths ago
Questions & Answers
Reported - view
0
IO Error: Cannot run program "chmod": error=24, Too many open files
We've started to get this error on both our development and production environments in the last two weeks. This happens when running a load either from the scheduler or manually selecting Load on a…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
10 mths ago
3
replies
31
Questions & Answers
Answered
Answered
Re: Log Retention
Okay, thank you. I just wanted to make sure there wasn't something already existing before I created it. On a side node I ran into a permission problem with the catalina log file rotation.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
11 mths ago
Questions & Answers
Reported - view
1
Log Retention
Is there a global setting for log retention for all of the various logs under the analytics and loader services?
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
11 mths ago
4
replies
64
1
Questions & Answers
Re: Limit for SQL statement size with Incremental Load?
Hi @Ahmed Moawad . I first noticed it on 4.5.9 but I was never able to figure out why the selection would work sometimes but not others. We are now on version 4.6.
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
11 mths ago
Questions & Answers
Reported - view
0
Limit for SQL statement size with Incremental Load?
I'm having a strange issue while configuring incremental loads on a table with a large number of fields (280). If I paste the SELECT statement that lists all of the fields individually with the…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
11 mths ago
3
replies
35
Questions & Answers
1
HOWTO: Unpivot a table with python
Related to the pivoting of data I also needed to find a good way to unpivot data, specifically from the census data. The data comes with age groups in separate columns: Year, State, City, Under_5,…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 yr ago
1
reply
38
1
Questions & Answers
0
Load Order - Extract and Load Question
Incorta 4.5.9 We have a schema where a table in the schema is loaded from a table in the same schema so I have set the load order for the second table to load after the first table.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 yr ago
30
Questions & Answers
1
HOWTO: Pivot a table with python
I have worked on finding a good way to pivot data and have finally settled on a method that works really well. One benefit of this is if new fields are added it automatically creates the additional…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 yr ago
58
1
Questions & Answers
0
Uploaded data file via sftp - Not showing up in list unless refreshed by Super User
We are working on an automated system for uploading data files and the upload is working correctly. The problem we are having is that the any new files won't show up under Data Files in the…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 yr ago
1
reply
22
Questions & Answers
Re: Using a Business View to Update a Historical Table
Hi Dan Thanks for the reply. Yes, that is essentially what I'm doing now and it's working. My question is more of if there is a better way or a reason I shouldn't do that.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 yr ago
Questions & Answers
Reported - view
0
Using a Business View to Update a Historical Table
How bad of an idea is it to use a business schema as a source for a historical table in schema? We have a requirement to keep a snapshot of customer data on a monthly basis.…
Ryan Sather
Incorta User
Gate City Bank
Ryan_Sather
1 yr ago
3
replies
39
Questions & Answers
Incorta User
Ryan Sather
Ryan_Sather
Gate City Bank
Fargo, ND
20
6
0
Follow
Login
Sign Up
Home
Community
Questions & Answers
Implementation Best Practices
Events
Knowledge Base
Product Announcements
Learn
Help Articles
Product Videos
Introduction to Incorta (17 Videos)
How To Videos
Tags
View all tags
Product Announcement
Incorta 4.9
is now Generally Available (GA)!!!